Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |