Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
HamidBee
Power Participant
Power Participant

The categories on the chart suddenly became disorganised as soon as I added a colour measure.

HI All,

 

I added a colour measure onto my chart and the categories labels across the x axis just reshuffled and everything went haywire. Please help!

Just a side note one thing I noticed is that I had to sort the months manually as when I tried to sort it automatically it wasn't in order which I found strange. 

 

Also does anyone have an idea on how to remove the padding around the chart, I found the top part to be super thick and I was really just looking to fill all the edges up.

 

Lollipop2.png

1 ACCEPTED SOLUTION
HamidBee
Power Participant
Power Participant

This is the strangest solution I've seen to date. I figured it out accidently whilst trying everything under the sun. Reset the category labels and then click 'back to report' then click 'save'. This will fix the issue. Do not click 'save' first. If you click 'save' first the axis will remain disorganised. 

 

Problem.png

View solution in original post

1 REPLY 1
HamidBee
Power Participant
Power Participant

This is the strangest solution I've seen to date. I figured it out accidently whilst trying everything under the sun. Reset the category labels and then click 'back to report' then click 'save'. This will fix the issue. Do not click 'save' first. If you click 'save' first the axis will remain disorganised. 

 

Problem.png

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! It's time to submit your entry.

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.