Incorrect Month label in clustered column chart

[steen_p]

Hi,

I'm trying to make a clustered column chart, where I'd like to add a trend line. In order to do that, I have to set the x-axis to continuous as well as change my dimension to a Date field rather than a Month Year field (but both fields comes from a date dimension). My data in this case is on a month level, so I only have the last day for each month as the Date in my date dimension. 

When I add the date, the label in the chart, is changed to a Month Year value as you see below and furthermore, it seems it's being "shifted" one month. E.g. on the highlighted column below, the label says Mar 2019, but the actual date is 28-02-2019.

My question now how to correct this? And also, how can I control what it being showed as label - how do I e.g. force it to show the Date I have in my field. If I change the vizual to e.g. a Table, it's shown as a Date like it is in the  table.

The data is coming from a Tabualr Model and in there, the Date field is marked as a Date field and formatted as dd-mm-yyyy and that works as it should in e.g. Excel.

[v-lionel-msft]

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.

[steen_p]

Hi,

Thanks for the answer. I'm getting my data using a direct query to a Tabular Model, so I don't have the options to change the type of the Date field in Power BI.  I also still don't understand why it behaves differently for a continious and a categorial X-axis. The value in the data field are still the same so why does it show a Month-Year in one situation and the full date in the other? And also I don't see why it shows "Jan - 2019" on the label when the date is actually "31-12-2018".  I can't see the reason for why this differes depening on the X-axis being continious or categorial.

I wanted to add a Trend line to the chart, and that was why I would like to make it continious, so just changing that doesn't really solve my problem :-(.

Regards

Steen