Forum Discussion
dokat
Post Prodigy
Post ProdigyMissing 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 Userdokat , 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
dokatPost Prodigy
Post Prodigyamitchandak 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