Bar chart - adding rank numbers for easier identification of the Element's position

[Talos]

Hi,

I was wondering if it is possible for a bar chart to display ranking figures on the left side of the chart (as per the blue numbers in the below/image example):

Something like this ranking will help the User/Viewer when they are looking for a certain Local Authority, and it is a bit ridiculous for them to have to count (sometimes even going with the index finger over the screen) to see where 'Sunderland' is: is it the 9th or does it rank 12th?..

Any help will be great! I kept looking but I could find nothing on this. Cheers!

[Anonymous · Accepted solution]

Hi @Talos 

@Tahreem24 Thank you very much for your timely reply. Please allow me to share other methods here.

I understand your needs and this is a very good idea. However, power bi does not support adding sort on the left side of visual.

However, I can show you another way.

You can create a measure dynamic calculated ranking and add it to visual tooltips so that when you view one of the bars, you can clearly see how it is sorted.

Here's some dummy data

“Table”

Create a measure.

Rank = 
RANKX(
    ALLSELECTED('Table'),
    CALCULATE(SUM('Table'[VALUES])),
     ,
    DESC,
    Dense
)

Here is the result.

Regards,

Nono Chen

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

[Talos]

None of the links work: "Restaurant Mangement Dashboard" or any of the other ones...

[Talos]

I think that the table-in-front-of-the-chart approach is a bit rudimentary, as I also have a slicer with Local Authorities, allowing Users to select just a few of them if they want to visualise just those and see how they compare to each other. And so the table would not be in line with the positions of the selected Local Authorities; plus, the ranking may not update to say 2, 1, 3 for example (if 3 Local Authorities have been selected). But thank you for this suggestion: it is an idea which may work for a static chart.

[Tahreem24]

@Talos You can take table visual and use this ranking column in it and place it wisely before the bar chart so it would look like same as shown in your pic.