Have you ever wanted a slicer or filter in your Power BI report to select the most recent date by default (or something similar) when it is opened? In my experience this is quite a common request, and in this post I’ll share some solutions I’ve been experimenting with. Isn’t this already on Microsoft’s roadmap?…
Introduction In my previous post Creating alias columns for calculation groups I showed how to create alias columns containing alternate names for calculation items in a calculation group by using the Group By Columns property. To recap: By setting the Group By Columns property of any alias columns to be the original calculation item column,…
Quick Summary Introduction The purpose of this post is to show how to add an “alias column” to a calculation group, containing alternate names for calculation items but functioning in the same way as the original calculation item column (the column containing the names of the calculation items). To begin with, did you know you…
