Change selected value in slicer with embedded report and Powerbi Client

[Grasmachien]

We have a report with a filter / slicer with a set of dates.
Basically what we want is to always pick the latest date available when a user loads the embedded report.

My colleague which is building the report can't find a way to make it work so I tried making it work in the web app by applying a filter. Unfortunately the filter only removes all other dates from the slicer and does not even select the one I want.

Is there a way to achieve this result?

[Anonymous · Accepted solution]

Hi @Grasmachien ,

As far as I know, Power BI doesn't support to select the latest date in slicer automatically. 

Here I will share you some workarounds.

1. Default slicer selection (latest date) in Power BI

Create a calculated column in Date table with "Today" and then you can select it in slicer to make your report show data for today.

2. Slicer: Default to latest date in data set

You can create a filter measure and add this measure into all visuals in your embed page and set it to show items when value = 1.

Best Regards,

Rico Zhou

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