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,
Is there a way to create an index or rank measure for the following graph, where 'Unknown' is always displayed on the extreme right-hand side of the graph, regardless if it has the lowest value or not?
Thanks in Advance
Solved! Go to Solution.
I am assuming your value is from a measure. In my sample I have another measure that checks the value and returns 0 if it is "Unknown".
Ranking =
VAR _Value = SELECTEDVALUE ( YourTable[Value] )
RETURN
IF ( _Value = "Unknown",0,[Total Amount])
Then I can add this second measure as a tooltip to the chart which will then let me sort by it.
I am assuming your value is from a measure. In my sample I have another measure that checks the value and returns 0 if it is "Unknown".
Ranking =
VAR _Value = SELECTEDVALUE ( YourTable[Value] )
RETURN
IF ( _Value = "Unknown",0,[Total Amount])
Then I can add this second measure as a tooltip to the chart which will then let me sort by it.
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |