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

Sdílet
Vložit
  • čas přidán 9. 02. 2024
  • 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/...
    ✅Pbix File:-
    drive.google.com/file/d/1ImPc...

Komentáře • 4

  • @sumitkumarpatel136
    @sumitkumarpatel136 Před 5 měsíci

    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.

  • @soumyaraninayak8208
    @soumyaraninayak8208 Před 5 měsíci

    informative content 🎉

  • @kalyank2638
    @kalyank2638 Před 5 měsíci

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

  • @govindtribhuvan6344
    @govindtribhuvan6344 Před 5 měsíci

    Plz explained what if we are working on feb 2024