Forum Discussion
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 control that? I want that the SINGLE SELECT is always the newest one.
Many thanks.
5 Replies
Hi powerbityro
Many posts with the same question.
https://community.powerbi.com/t5/Desktop/Setting-the-Default-Value-of-a-Slicer/td-p/16442
https://community.powerbi.com/t5/Desktop/KPI-Filtered/m-p/274022#M122559
And more if you search.
Cheers!
AIt is possible to use
if Date.IsInCurrentMonth( [Date] )
then "Current Month"
else [Month]with Output current date 2019/1 instead of the text "Current Month"?
I have no Date. Only Year and Quarter and Year/Quarter.
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
