Forum Discussion

powerbityro's avatar
powerbityro
Helper II
7 years ago

SINGLE SELECT last date

Hi All :robotindifferent:   I have ich Slicer with   2019/1 2018/4 2018/3   and choose SINGLE SELECT with 2019/1. But when I get new Data with 2019/2 the choosen Button is still 2019/1. Can I...
Need Help
dax's avatar
dax
Community Support
7 years ago

Hi powerbityro

 

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