Forum Discussion
Slicer default value max value based on ID
Hello,
I want to set default value to slicer based on max ID Value in of my fields. is there any way to do?
Hint: max value is changed every time based on user selections in other visuals and slicers. it is not a constant value
4 Replies
Hello As9124141636 ,
you create a new column with the following measure then use this new column as a slicer alway selected as max ID.
Max ID = IF('Table (2)'[ID] = MAX('Table (2)'[ID]), "Max ID",'Table (2)'[ID])If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hint, max value is changed every time based on RLS.
I've never experienced this RLS case, so you could test it.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
