Set Default Slicer Selection to Current Year or Month in Power BI
4.1 هزار بار بازدید -
20 ساعت پیش
-
Hello Everyone Welcome back to
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:- docs.google.com/spreadsheets/d/1MuM41ZYZNuVP56zlP1…
✅Pbix File:-
drive.google.com/file/d/1ImPcK-wN2RvVLMTBEcA_s08W_…
20 ساعت پیش
در تاریخ 1403/07/17 منتشر شده
است.
4,111
بـار بازدید شده