Is it possible to add rank values in bar graph in power bi

[gerard-kouadio]

Hello.

I have 43 categorical values, and I constructed a bar chart using the temperature values. this chart is sorted, but i want to add the rank in the bar chart i built. I used dax formula to calculate the rank and I want to display these rank values in the grap bar.

I spent a lot of time looking for how to do this, but I can't. I need help please. If this is not possible, I would like to know if it is possible to use 2 variables in abscissa: one to display the 43 categorical values and the other to display the ranks.

[Anonymous · Accepted solution]

Hi @gerard-kouadio ,

First of all, for the ranking value, I would recommend you to add a new column if it is for your subsequent operation, through this DAX sytnax:

Rank = RANKX('Table','Table'[Value])

and then you can create a clustered column to meet your needs, as the following shows,the categories are shown on the x-axis, along with the corresponding ranking values

If this meets your needs, you can also refer to my test file.

Best regards,

Community Support Team Selina zhu

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

[Anonymous]

Select the column you want to sort in the fields pane (right hand side), and this will show 2 new ribbons at the top ( Table Tools, Column Tools).

Select Column Tools, and next to summarisation properties is a Sort option. From the dropdown list, select the calculated column/formula you have created and it will apply the sorting option to the column.