Forum Discussion

steen_p's avatar
steen_p
Helper II
6 years ago

Incorrect Month label in clustered column chart

  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 ...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

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's avatar
    steen_p
    Helper II
    6 years ago

    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