Set Default Slicer Selection to Current Year or Month in Power BI

preview_player
Показать описание
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])

✅Pbix File:-
Рекомендации по теме
Комментарии
Автор

Very informative topic and the way of your explaining is much appreciated.One request from side that it will be better to share us the latest technology videos relating to different problems so that we'll get a chance to learn.

sumitkumarpatel
Автор

Nice ..but what if we have data till 2023 only and we writing the code in 2024?

kalyank
Автор

Plz explained what if we are working on feb 2024

govindtribhuvan