Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jsjcjsjc
Frequent Visitor

how to add ranking in clustered column chart

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

jsjcjsjc_0-1654756619375.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

RicoZhou_0-1655085787619.png

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

RicoZhou_1-1655085810205.png

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

RicoZhou_0-1655085787619.png

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

RicoZhou_1-1655085810205.png

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.

Cool ! Thanks

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.