Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a month slicer which shows the last 13 months (by using Reletive Date in last 13 months). When a user first opens the report, I want the Month slicer to have the current month automatically selected. I also want the user to be able to select any of the other 12 months as well.
How can this be done?
Solved! Go to Solution.
Hi @Anonymous ,
You could use ISFILTERED() function.
If the slicer was not filtered, then show the special value, if it was filtered, show the filtered value.
Something like below.
Best Regards,
jay
Hi @Anonymous ,
You could use ISFILTERED() function.
If the slicer was not filtered, then show the special value, if it was filtered, show the filtered value.
Something like below.
Best Regards,
jay
@v-jayw-msft, thanks for the suggestions. I have created this measure below
SlicerMeasure1 =
@Anonymous , have a column like below in you date table and sort that on month year sort and save current month /this month on slicer
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
or
Month Type = Switch( True(),
eomonth([Date],0)= eomonth(Today(),0),"Current Month" ,
Format([Date],"MMM-YYYY")
)
refer to the video: https://www.youtube.com/watch?v=hfn05preQYA
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |