how to add ranking in clustered column chart

[jsjcjsjc]

similar like the image below ?, I'd like to add 1,2,3,4,5... in clustered column chart

[v-rzhou-msft · Accepted solution]

Hi @jsjcjsjc ,

Here I will give you some suggestions.

Firstly, you can create rank measure or rank calculated column.

Rank Measure = 
RANKX(ALL('Table'),CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Category])),,DESC,Dense)

Rank Column = 
RANKX('Table',CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Category])),,DESC,Dense)

1. You can add Rank Column in Legend.

2. You can add Rank Column/Rank Measure in Tooltips. However, rank will only appear when you hang over your mouse.

3. You can refer to this post to achieve your goal by creating calculation group in Tabular Editor.

For reference:

Data Labels! Formatting 100.00% as 100%

Best Regards,
Rico Zhou

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

[jsjcjsjc]

Cool ! Thanks