Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
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.
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.
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.
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.
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
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.
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.
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.
Thank you
#Unsubscribe