Forum Discussion
Between slicer max limit dynamic
Hello, My slicer now is limited by a generateseries from 0 to 400. But i want to put the max dynamic, to be the max number between these 2 of top. In this example is 103,78%. Is this possible?...
Greg_Deckler
Community Champion
Community ChampionAnonymous Create a measure like:
Measure Flag = IF(MAX('Slicer'[Value]) < MAX([Measure1],[Measure2]),1,0)
Where Measure1 and 2 are your measures in the card visuals. Then just filter the visual where [Measure Flag] = 1
ok that works. But when the values from cards changed because of some filter, that slicer stays with the initial max value (103,78%)...
- Greg_Deckler
Anonymous I don't know enough about your data to provide a specific answer, but you could wrap an additional MIN or MAX in your formula like:
Measure Flag = IF(MAX('Slicer'[Value]) <= MIN( MAX([Measure1],[Measure2]), [some other calculation] ) ,1,0)