Forum Discussion
Can't sort clustered column chart
Hi, thanks for dropping by.
Okay I have a clustered column that I used to calculate the average rating (rating is from 1-5) from flight passengers on different services they receive from an airline.
I want to sort this clustered column in a descending order. But can't seem to know the best way to get this done. The sort axis option (as in the pic) isn't helping.
For taking out your time to read through, I appreciate that.
Hi driplytics
Which field do you want to sort by descendingly? From your screenshot, it is sorted by Average of Baggage Handling descendingly at present. According to the position, Average of Baggage Handling might be the first column (on the far left) in each group of columns rather than the highlighted ones. If so, the result looks correct based on your current setting.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
3 Replies
- lbendlin
Super User
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 
v-jingzhangCommunity Support
Hi driplytics
Which field do you want to sort by descendingly? From your screenshot, it is sorted by Average of Baggage Handling descendingly at present. According to the position, Average of Baggage Handling might be the first column (on the far left) in each group of columns rather than the highlighted ones. If so, the result looks correct based on your current setting.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.Thanks for your response. I found out that might not be the best way to visualize my data and I changed to another visual. That's resolved. I appreciate
