Slicer if max that

[Anonymous]

i created and publish a report on june 5, every day i have to open and put the date slicer on the right date. Is there any way to after i update the report the max date of the slicer is always set on the max date? ( like put a max date function on the slicer, or something like this)

Thanks

[dax · Accepted solution]

Hi Postigo,

As  I know, we  can’t use a measure in Slicer, so if you want to make slicer always select newest date, you could try to use below method, create a column like below, then use this for Slicer

Column = if('Table'[Date]=MAX('Table'[Date]),"a",'Table'[Date]&"")

You could refer to video or Power BI Tutorial: Dynamically update Date slicer to show Current Date for details.

In addition, if you want to get the newest day based on current day(today), you also could use relative slicer, it will automatically change.

Best Regards,

Zoe Zhi

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