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

[HamidBee]

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.

 

[HamidBee · Accepted solution]

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.