Forum Discussion
How to set Yesterdays date as default value in date slicer?
Hi all , i have a date slicer in my report , i want to show the yesterday date as default value when we land on the report. Can you help me how this can be done. I am using direct query metho
Anonymous Right, so you would set the slicer to "Yesterday" and save it. Publish it, now Yesterday should be the default for the report.
Greg_Deckler
Community Champion
Community ChampionAnonymous So, a lot of people solve this by adding a column like:
Column =
VAR __Yesterday = TODAY() - 1
RETURN
IF([Date] = __Yesterday,"Yesterday",[Date] & "")
You use this column in your slicer, set it to Yesterday, save and publish.
Hi Greg_Deckler ,
Thanks for replying this is working but i have to show the yesterday's date when we land on the report.- Greg_Deckler
Anonymous Right, so you would set the slicer to "Yesterday" and save it. Publish it, now Yesterday should be the default for the report.