fixing columns in cluster column charts

[Rahul_SC]

Hi I have a made a cluster column chart. I want to fix the sequence of the columns in the chart. 

Whenever, I am filtering by slicer, the columns of the chart is changing its positing. In the below picture, I want to fix axis names (the alliance, 2m alliance, ocean alliance, others) and I want to keep in an order where the alliance should be at first place whether I filter for difference categery.

your suggestions would help me.

[AlexisOlson · Accepted solution]

It looks like you want to sort by the x-axis field, but not alphabetically?

If you already have a column with the sort order you need, then use the Sort By Column feature:

https://radacad.com/sort-by-column-in-power-bi

If not, you may need to create a new column or table to define the order you want:

https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi

[Anonymous · Accepted solution]

Hi @Rahul_SC ,

Please refer to my pbix file to see if it helps you.

Create a new table with name column.

Then add an additional column.

Then create relationship between the tables. Like the following:

Then sort the column by Custom.

If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output.

Best Regards

Community Support Team _ Polly

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

[AlexisOlson · Accepted solution]

It looks like you want to sort by the x-axis field, but not alphabetically?

If you already have a column with the sort order you need, then use the Sort By Column feature:

https://radacad.com/sort-by-column-in-power-bi

If not, you may need to create a new column or table to define the order you want:

https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi

[Rahul_SC]

Hi, is my query confusing ?