Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
@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
ok that works. But when the values from cards changed because of some filter, that slicer stays with the initial max value (103,78%)...
@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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |