Forum Discussion
Bar Chart ranking
Hi , gdxy
According to your description , you want to display the rank number in the x-axis of the bar chart. Right?
The X-axis of the bar chart shows the names of the fields we placed, and if we want to show the corresponding rankings additionally, we need to create a new column to represent the relationship between the name and the rank.
(1)This is my test data:
(2)We can create a calculated column :
Column = [Name] & UNICHAR(10)& RANKX(ALL('Table'[Name]) , CALCULATE(SUM('Table'[Count]) , ALLEXCEPT('Table','Table'[Name])),,,Dense)(3)Then we use this [Column] to replace the x-axis field in the visual.There is no way to achieve line breaks in bar charts.The result is as follows:
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , gdxy
According to your description , you want to display the rank number in the x-axis of the bar chart. Right?
The X-axis of the bar chart shows the names of the fields we placed, and if we want to show the corresponding rankings additionally, we need to create a new column to represent the relationship between the name and the rank.
(1)This is my test data:
(2)We can create a calculated column :
Column = [Name] & UNICHAR(10)& RANKX(ALL('Table'[Name]) , CALCULATE(SUM('Table'[Count]) , ALLEXCEPT('Table','Table'[Name])),,,Dense)
(3)Then we use this [Column] to replace the x-axis field in the visual.There is no way to achieve line breaks in bar charts.The result is as follows:
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you for your answer, it inspired me to make what I would like to show.