Filter on single date with automatic update of default value

[Anonymous]

Hi,

I am building a dashboard with a fact table and a calendar table, focused on daily KPIs.

The main use case is to display previous day data on the default view (when dashboard open or get subscription email).

But it should be possible to also go to a specific day to see historical performance or current day partial state.

In Tableau i was able to do this with a date filter that was updated automatically to N-1 date upon dashboard opening. 

Is there a way to work with slicers/filter to allow this? Solutions I have so far are not satisfying (ex: duplicating my report page with different filters)

I have several issues:

->Is there an "elegant: way to pick a single date ? I see a date picker in the Slicer when using ranges (before,after,between), but not for simple date selection.

->Is there a way to dynamically update the default filter value - set the Date filter to Yesterday's date when the report is opened or refreshed?

It seems like a common requirement but I could not find an elegant solution to this issue. 

[V-lianl-msft]

Hi @Anonymous ,

1.The built-in slicer can choose the following formats to meet your needs.

2.Current power bi doesn’t  support you set up default value on slicer.

You can vote below idea  and add comments to  to help improve slicer.

Default Selected Slicer or Tile-By Value Configuration

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , As you can not add the filter to the dashboard( Power bi Service Dashbaord). You need to add a full report (from power bi desktop) to the dashboard.

There is no way to default the date with function. You can find alternate in my video :https://www.youtube.com/watch?v=hfn05preQYA

[Anonymous]

Oh my bad, I wrote dashboard because I'm used to Tableau terminology, but it's actually a Report in Power BI.

Thanks for the info, I'll try to look at the video later (youtube isn't available at my workplace)