Forum Discussion
Helper IDynamically Select the latest value in slicer
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
3 Replies
- YukiK
Impactful Individual
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
- ribisht17
Super User
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 
shubhamc_002Thanks YukiK for providing workaround. May be for time being this workaround will work. Hope, Microsoft will release some feature to achieve this very soon.
