Dynamically Select the latest value in slicer

[shubhamc_002]

HI Team,

We have one requirement in which Text type data slicer should preselect the latest  value based on updated data.

eg:

FY22-01 is latest and we have list including FY21-01,FY21-02 ,.............. FY21-10 and slicer should preselect FY22-01 but entire list also should be available in slicer. if we get FY22-02 data in our system than FY22-2 should be preselected.

Appreciate your help and quick response on the same.

Thanks

[shubhamc_002]

Thanks @YukiK  for providing workaround. May be for time being this workaround will work. Hope, Microsoft will release some feature to achieve this very soon. 

[ribisht17]

@shubhamc_002 

Please check https://www.youtube.com/watch?v=JlVHsZUk1nc&t=4s

Thanks,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

[YukiK]

You need to create a custom column that basically sets a value for the most recent date like "Most Recent". That way, you can have it selected and most recent value won't change over time. Hope that makes sense!

I know Microsoft working on this solution or has come up with a feature