How to Load Yesterday’s Data as Default in Power BI Report

[manoj_0911]

Hello Power BI Community,

I am looking for a way to configure a Power BI report to automatically load and display data from yesterday by default when the report is opened.

Any suggestions or examples would be greatly appreciated!

Thank you!

[Kaviraj11 · Accepted solution]

Hi,

You can create a calculated column:

slicer date = SWITCH(TRUE(),'Calendar'[Date]=TODAY(),"Today",'Calendar'[Date]=TODAY()-1,"Yesterday",FORMAT([Date],"YYYY/MM/DD")&"")

Use the column in the slicer & make sure to select 'Yesterday' and you can exclude 'Today' from the filter pane. The slicer will always be default to Yesterday whenever your data gets refresh.