Best way to visualise ranking

[itchyeyeballs]

Hi all,

Does anyone have any tips on the best way to visualise rankings? i.e. where 1 is best and 10 is worst?

As Power BI does not have the ability to invert Y axis using a bar/line chart confuses users as the lowest ranked have the biggest bars. We have tested multiplying by -1 by this confuses users as the inverse ranks are shown.

Any ideas appreciated!

[v-yuta-msft]

@itchyeyeballs ,

In this senario, I would suggest you to use DAX function RANKX(), you can set Ascending order or Descending order in RANKX() function. More details please refer to: https://docs.microsoft.com/en-us/dax/rankx-function-dax.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[itchyeyeballs]

Hi,

Thanks for the reply, we can calculate the ranks no problem its how to visualise them is the issue, I cant find a visual in Power BI that lets me represent 1 = good, 5 = ok, 10 = bad

There are lots of separete requests for an invert Y axis function in the ideas section which would help, Excel graphs make this easy.

[v-yuta-msft]

@itchyeyeballs ,

You may create a measure using SWITCH() function like pattern below:

Flag =
SWITCH ( Table[RANK], 1, "good", 5, "ok", 10, "bad" )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[itchyeyeballs]

Thank you @v-yuta-msft ,

My explaination may not have been clear though.

We have a table with 100+ rows, each row represents a seperate orgnaisation and has a unique rank column based on thier performance. At the moment the visuals all give the impression that the worst performs are the best

For example, in the bar chart below higher ranks (worse performance) give a larger bar which is confusing

[v-yuta-msft]

@itchyeyeballs ,

So the rank column is generated by rankx() function, right? RANKX(<table>, <expression>[, <value>[, <order>[, <ties>]]]), in order parameter you can use "ASC" instead of "DESC".

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[itchyeyeballs]

Hi,

Yes it is calculated like that.

The problem is users always assume that a bigger bar is better, its not intuitive for them when the smallest bar signifies the best.

[v-yuta-msft · Accepted solution]

@itchyeyeballs ,

Use "DESC" instead of "ASC" and check if the bar chart can reverse.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[itchyeyeballs]

Thank you

#Unsubscribe