How to set latest value as default value in slicer ?

[Anjaneyachari]

Hi All...

I have a column for the year. So, in the slicer, I want to show the most recent value by default. When the user opens the report , the latest value should be displayed in slicer and the user should be able to select other multiple values.
For example, now i have recent value is 2023, in future 2024 is the recent value in column, it should be the default value.

so Silcer should change dynamically.

[Thennarasu_R · Accepted solution]

Hi @Anjaneyachari 

for this scenarios you need to set one text name in Claculated Column to Latest year or month then it will automatically select the latest month .For this one no other way to acieve from my side.

If it have helpful to you give a kudos and Accepted a Solutions.

Thanks ,
Thennarasu

[FreemanZ]

hi @Anjaneyachari 

this tutorial shows the way:

https://www.enjoysharepoint.com/set-default-value-in-power-bi-slicer/#:~:text=Power%20BI%20Slicer%20...