Most recent date by default in slicer but all values still displayed

[ChrisTof]

Hi,

I have this visual table :

I'm using preselected slicer to set a default value as described in this post : Solved: Select most recent date (by default) in slicer - Microsoft Power BI Community

But i get this :

The default value is the most recent date but in my slicer i only see this date.

I want to see all the dates but the most recent is selected by default, like this :

How can i do ?

Thanks a lot

[Anonymous · Accepted solution]

Hi @ChrisTof ,

Please check the pbix file.

Most recent date = 
VAR _max_date = CALCULATE(MAX('Table'[Date]),ALL())
VAR _selected_date = SELECTEDVALUE('Table'[Date])
RETURN
_selected_date = _max_date

_PreselectedSlicer = 
DATATABLE(
    "IsDirtySlicer1", BOOLEAN, 
    {
        {FALSE()},
        {TRUE()}
    }
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum