The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
similar like the image below ?, I'd like to add 1,2,3,4,5... in clustered column chart
Solved! Go to 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.
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.
Cool ! Thanks