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
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".
VAR _Value = SELECTEDVALUE ( YourTable[Value] )
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.
View solution in original post
@jdbuchanan71 Thank you - this is exactly what I was looking for.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.