Forum Discussion
Change selected value in slicer with embedded report and Powerbi Client
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?
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.
1 Reply
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.