Forum Discussion
BICrazy
Helper II
Helper IIRanking in Descending Order
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 val...
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.
jdbuchanan71
Super User
Super UserI 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.
BICrazyHelper II
Helper IIjdbuchanan71 Thank you - this is exactly what I was looking for.