Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Sorting Bar Chart

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!

 

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    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

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago

    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.