Sorting Bar Chart

[Anonymous]

Hey Community, 

I created some bar charts as visuals and the bars are automatically sorted by size (see picture below). Apparently I want to sort them in a fixed order which is Z27, Z30, Z33. How is this possible?

I really appreciate your help!

Thanks!

[ChiragGarg2512]

@Anonymous , For these 3 just sort the x-axis values, but if there are more values like this create an ID column for this so that every ID can be associated with a Z value in ascending order and then sort by column can be used.

[Uzi2019]

Hi @Anonymous 
You have to do either sort by column option if you have proper sequence of sorting order. 

Or you need to create new custom column lik below:

Sorting = SWITCH(TRUE(),

            Table[Campaign Type]="Z27", "1.Z27",

            Table[Campaign Type]="Z30","2.Z23",

            Table[Campaign Type]="Z33","3.Z33"

            )

Use above column in X axis

Or 

You ca simply change the setting:

If my post helps please give kudos and accept it as a solution!
Thanks