Forum Discussion
Dynamic Date Slicer
Hi BarnyQuack
Using Tabular Editor, you need to levareage the Group by Columns property to "store a filter by using an alternate value, which represents the key of the entity." Power BI uses this key to store the filter, allowing the corresponding filter value in the visual to change dynamically. For instance, if May-24 is selected in the visual and currently has a key of 0, when June arrives, May will shift to a key of 1, and June will take the key of 0. Please note that if you're using a dropdown, although the filters have actually changed, the slicer selection doesn't.
Further reading in the video description: https://youtu.be/MrEAZREQuXM
Super UserBarnyQuack , we usually use a current month text in a new column and use that as default
Need to be adjusted as per need
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1*month(Today())),"Last year Last Month" ,
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
Many thanks for the advice! That is much appreciated.
That is a great idea, My user wants to keep their date hierarchy i.e. year/quarter/month.
Is there a way to incorporate that?