Chart - x axis year mismatched from data year

[m_ski_co]

Wondering if anyone can solve this likley very simple challange.  The x-axis on my chart shows a year that is one year ahead of the year represented by the underlying data.  I have no idea why this is.  The Data Type of the source data is Date.  Any suggestions would be very helpful.  Thank you.

[v-rzhou-msft]

Hi @m_ski_co 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[v-rzhou-msft · Accepted solution]

Hi @m_ski_co 

I build a table to have a test.

Firstly I try to use Year column in Axis but my result is that I can't see the exact date when my mouse hover over the line visual.

If you exactly use hierarchy in Date like  amitchandak replied before, you may change to the Date column instead of hierarchy.

If this reply still couldn't help you solve the problem,  please show me more details like your data model,the column you use in the Line chart or provide me with your pbix file sample by your Onedrive for Business.

Best Regards,

Rico Zhou

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

[amitchandak]

@m_ski_co , You are using date Hierarchy or Or year column. Check the data type.