Forum Discussion
Slicer max date
I have a slicer set up with Fiscal Yr, Qtr, and Mon from a dim date table. I want this slicer to have a max date of the last month (Data is updated at every month beginning, with last months data). So I want my current max date to be Apr 23 and next month May 23. Currently my slicer is running open ended and dates up to 2100 can be selected.
How can I limit my slicer to just through last month?
Hi Dev_B_PBIing ,
According to your description, here are my steps you can follow as a solution.
(1) We hava a date table.
Date = CALENDAR( DATE(2022,1,1),DATE(2025,12,31))(2) We can create a measure.
Flag = IF(MAX('Date'[Date])<= EDATE(TODAY(),-1),1,0)(3) Screening of slicer.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Dev_B_PBIing ,
According to your description, here are my steps you can follow as a solution.
(1) We hava a date table.
Date = CALENDAR( DATE(2022,1,1),DATE(2025,12,31))(2) We can create a measure.
Flag = IF(MAX('Date'[Date])<= EDATE(TODAY(),-1),1,0)(3) Screening of slicer.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That worked! Thanks so much!
