Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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?

 

Thanks,

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        3 years ago

        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)