Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Set Default date in slicers

Hi Team, I need to set default date as a slicer in power bi, for eaxple i have between slicer and i select date as 01/01/2024 to 30/4/2024, if user open file as may 1st then i want show default datea...
data protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Tob_P's avatar
Tob_P
Icon for Helper V rankHelper V
2 years ago

Provided there is data within your model that has today's date (or in your example, if there is data on 01/05/2024, then it will show the dates you want), then add a Relative Date filter to your slicer and set that to this calendar year.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Tob_P  Hi I have future dates as well in my date table like june 2024, july 2024. we can't update file as daily if we insert date as today date in table so even i have future dates in report still user open the report in that day i want show date as that day only.

    • Tob_P's avatar
      Tob_P
      Icon for Helper V rankHelper V
      2 years ago