Line chart year over years showing separate months for multiple years

[tsakoc]

Trying to show line chart with year over year and month but it only works if I use the integer value of the month and not the text month name on the axis.

[v-joesh-msft]

Hi @tsakoc ,

After my test, everything works fine on my side. Please kindly share your sample data if you don't have any Confidential Information.

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ET2GHEvHAxRFkaojha...

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

In your Model view, go and check for the sort column for Month, it seems like it year-month kind of column.

If not so.If possible please share a sample pbix file after removing sensitive information.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[cambrian]

Hi Amit,

If I send you a sample pbix file, would you be able to help me out? 

[tsakoc]

thanks so much. changed the sort field to integer for month of year and it worked. @amitchandak