Sort Column Chart

[work_1111]

Hello Community - I am trying to sort a column chart based on another column but when I select my visual, I do not get the Column Tools Pane. I would like my x-axis to sort in order by number of days overdue. Any tips?

[Anonymous]

Hi @work_1111 ,

You can refer the following links to get it by creating a custom sort dimension table:

Sort a Column with a Custom Order in Power BI - RADACAD

Solved: Sorting rows and columns in matrix visual - Microsoft Fabric Community

The detailed steps as below:

1. Create a dimension table

Item	Order
1-7 DAYS OVERDUE	1
8-30 DAYS OVERDUE	2
30+ DAYS OVERDUE	3
90+ DAYS OVERDUE	4
180+ DAYS OVERDUE	5

2. Combining the Sort Order Table with the Data Table

3. Sort by column

Best Regards

[work_1111]

@Anonymous This post did not work for me. Also I have other visuals on the page and it seems clicking the sort order column affects the other visuals. I just want to contain it to the one visual.

[Anand24]

@work_1111 ,
You can't have a specific sort order for a field/column in only 1 visual.
The only alternative I can see is create another column for the field, sort it separately and then take that new column in graph.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[christinepayton]

The columns tool pane is not attached to the visual, so select the column in the fields selector on the right and it should pop up there. Then go into the ellipsis menu for the visual once you have the column sort set and sort your axis by the column. 

[work_1111]

@christinepayton Thank you for your response, it did not resolve my issue though.