Forum Discussion
How do I custom sort columns within a cluster bar chart?
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
trinas this is because you have selected the visual and then gone to the editor bar at the top. Rather, you need to select the table with this column in it and then go to the editor bar.
Below is when the visual is selected and only format & data/drill is available:
Note the difference now when I select on a table with the appropriate column selected:
In your case, select your table the click on the "Phase" column then go to column tools, click sort by column & choose POS.
Gotcha - i don't have the table shown on the dashboard, only the visual. I tried going to the data section to sort it from there but it doesn't appear that that option is available there, only if I put the table in the actual dashboard?
Can you provide a screenshot of what you see?
Also, have you updated to the latest version of PBI (February 2021 release is newest I think)
yes I have the latest version