Forum Discussion
Missing Sort By Option in Bar Chart
Hi I have a data table with Pack Size and corresponding Sales. Pack Size is in text format. I created a calculated colum and converted pack size from text to number. Then i created clustered bar...
amitchandak
Super User
Super UserAnonymous , You can mark the pack size number as sort column of the text column
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Also check axis type, change it to categorical
amitchandak Thanks for your response. I'd like to sort it by dollar sales not pack size. It's a clustered bar chart. I looked at under Y-Axis it doesn't give me option to change it categorical. Please see below screenshot
- amitchandak
Anonymous , I can see Type under Y axis, When I use date or number on categorical axis