Be selected latest value on slicer as per new data update

[jeongkim]

Hi,

Is there any way to get selected latest value?

Hope to see W13 is selected, then when W14 updated then W14 selected, ... 

[v-zhengdxu-msft · Accepted solution]

Hi @jeongkim 

Certainly that can be realized, please try this:

First of all, I create a set of sample:

Then add a calculate column:

Column = 
VAR _NumTable =
    SELECTCOLUMNS (
        'Sheet1',
        'Sheet1'[Column1],
        "Num", VALUE ( MID ( 'Sheet1'[Column1], 2, 2 ) )
    )
RETURN
    IF (
        MAXX ( _NumTable, [Num] ) = VALUE ( MID ( 'Sheet1'[Column1], 2, 2 ) ),
        "last",
        'Sheet1'[Column1]
    )

This column can choose the max value and mark as the "Last" one:

Next add a slicer and select the last:

Finally if add a W16, the result is as follow:

Best Regards

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

[jeongkim]

Hi, 

There always should be the word 'Last' or something text, right?

Still good approach.