Forum Discussion
Line chart year over years showing separate months for multiple years
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.
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/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
4 Replies
- amitchandak
Super User
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/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601thanks so much. changed the sort field to integer for month of year and it worked. amitchandak
Hi Amit,
If I send you a sample pbix file, would you be able to help me out?
v-joesh-msftSolution Sage
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:
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.
