Slicer default value max value based on ID

[As9124141636]

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

[Idrissshatila]

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 👍

Follow me on Linkedin

[As9124141636]

Hint, max value is changed every time based on RLS. 

[Idrissshatila]

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 👍

Follow me on Linkedin

[As9124141636]

how if max value is changed every time based on user selections in other visuals and slicers. it is not a constant value