SINGLE SELECT last date

[powerbityro]

Hi All 

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. 

[dax]

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

[Anonymous]

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!
A

[powerbityro]

It 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"?

[powerbityro]

I have no Date. Only Year and Quarter and Year/Quarter.

[powerbityro]

I work in Direct Query Mode... so both solutions... MAX in Column and

if Date.IsInCurrentMonth( [Date] )
then "Current Month"
else [Month]

is not accepted. Is it than not possibe in DQ Mode or do you have some further ideas?