Incorrect Month label in clustered column chart

Hi steen_p ,

The problems you described does exist.
Problem 1:

“it seems it's being "shifted" one month.”

As tested,  the reason is that your date is not contiguous and you date also doesn't have the same time interval , but you set  X axis to contiguous. So it’s being "shifted" one month.

Problem 2:

“it seems it's being "shifted" one month.”

I think the reason is that you set [date] column like this:

When you choose ‘Date’, the chat only can show ‘Month-Year’.

Is it what you want?

If you want to get it , you can change the type of [date] column to Text:

Or Set the X axis to be ‘Categorical’:

Other than that, I don't think of any other way. If you do, please let me know.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.