Between slicer max limit dynamic

[Anonymous]

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?

Thanks,

[Greg_Deckler]

@Anonymous 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

[Anonymous]

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)