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.
Hi all, this is the issue I have. The measure shows a ratio value based on both selecting a ratio and a range. In the below screenshot i have selected "90%-100%" range, so it works perfectly as long as the user only makes one selection. But if multiple selections are done, i'm not sure how to deal with that in the red section below:
thanks!
Hi @chinex
Are those [Y Axis Selected Ratio] and [Y Axis Selected Ratio Range] from MAIN -Long Bar Consol SS ShkO Trend table?
If yes, just use this measure:
Y Axis Ratio Value =
AVERAGE('MAIN -Long Bar Consol SS ShkO Trend'[Value])
When you select items on the slicer, it will filter your table and you don't need to add filter to your measure.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
70 | |
48 | |
45 | |
19 | |
16 |