Missing Sort By Option in Bar Chart

[dokat]

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

[amitchandak]

@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-c

Also check axis type, change it to categorical

[dokat]

@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]

@dokat , I can see Type under Y axis, When I use date or number on categorical axis