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 chart and put newly created pack size (number format) to Axis. I'd like to sort the chart by sales. However after converting from text to number format, look of chart completely changed. Isort by option for the chart dissapeared. Is there a work around this issue? Please see below screenshot. Thanks
3 Replies
dokat , 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-cAlso 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
dokat , I can see Type under Y axis, When I use date or number on categorical axis
