Forum Discussion
How do I custom sort columns within a cluster bar chart?
Hello!
I am trying to sort the bars/legend by 50% DD, 100% DD, Trending Target Budget so that it shows the progression chronologically but can't figure out how to change that. I have no problem how the clusters are sorted, but I need the data to be sorted within each cluster in the order noted above.
Source data for reference:
I have tried adding a position column to try and get them in order but that didn't work, I tried changing the format of the source data and that didn't work, and I tried searching in the other community posts and couldn't find a solution. Help!!
Hi， trinas
Could you please tell me whether your problem has been solved?For now, there is no content of description in the thread.
As mentioned by sjrrkb123 , what you need is to sort the column 'phase' by column 'Pos' in 'column tools' . And the feature is available in 'data tab' rather than in 'report tab'.
Before:
After:
Please check my sample pbix file for more details.
Best Regards,
Community Support Team _ Eason
14 Replies
Hi， trinas
Could you please tell me whether your problem has been solved?For now, there is no content of description in the thread.
As mentioned by sjrrkb123 , what you need is to sort the column 'phase' by column 'Pos' in 'column tools' . And the feature is available in 'data tab' rather than in 'report tab'.
Before:
After:
Please check my sample pbix file for more details.
Best Regards,
Community Support Team _ EasonThank you! I guess I didn't understand the instructions from before but the screenshots helped a lot and it worked!!
Can you please show me how to sort with this dataset. The clustered bar should be sorted within each category.
So within vaccination: Covid should appear first, then Tuberculosis and then Cardia Arrest.
I need to do same with all groups
COVID Cardiac Arrest Tuberculosis Vaccination cost 10,185 1,500 3,000 Hospitalization Stay 11,000 8,000 4,000 Prescription Medicines 55,000 5,000 20,000 Additional Expenses 13,000 12,000 8,000 Outpatient Procedure cost 12,000 1,500 5,000 Thanks for your help v-easonf-msft
Did you sort the [Phase] column by the [Pos] column in your model?
I tried that but for some reason it won't let me - this is what it shows:
and what the data is to the left:
Did it give an error message?
