Set Default Slicer Selection to Current Year or Month in Power BI
Hello Everyone Welcome back to Milestone Creator. So, today In this tutorial, I am explaining how we can force current year or current period selection in slicer. For this demo, I am using a custom visual called Preselected Visual. Set Default Slicer Selection to Current Year or Month in Power BI.
✅Question:-
Set Default Slicer Selection to Current Year or Month in Power BI
✅Answer:-
Custom_Column =
if Date.Year(DateTime.LocalNow())=[Year]
then "Current Year" else Text.From([Year])
✅Date Set:- https://docs.google.com/spreadsheets/...
✅Pbix File:-
https://drive.google.com/file/d/1ImPc...