Forum Discussion
Multiple line graphs
Hello ,
Im hoping somone can help me with this. I am trying to Graph multiple years on the same graph. When i try to graph them on general scale (x axis) of 1 year it will only graph one point per/month. I would like grapall point in each month like the leeft graph does. basically I would like to have my Axises as diplayed in the right graph but all the data ploted liked the left graph will all data. Does anyone know if this is possible?
Graph 2Graph 1
8 Replies
Anonymous no it doesn't make sense what you are trying to achieve and not possible.
HI Anonymous
Do you have year and month in different columns.
If you have the complete date part in one column, use that column on the axis and to get the correct representation check the buttons on the top of the chart which comes up when the chart is selected.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Regards,
PranitAnonymous I believe you are going to end up spending a lot more time and I don't see any solution for it because the requirement is not practical.
Good luck
Anonymous , for the first visual you have I tried Date/month-year on-axis and year as the legend. Then I can have different colors for each year.
Hi Anonymous ,
Here is a work-around you can try:
1. Drill your data to day level or keep date in X-Axis
2. Disable X-Axis labels
3. Add a text box or image showing month in X-Axis
Note: This would be best only in cases of static data representation since months will always remain same
Hi Anonymous ,
If you want to show all values in one line chart, it will only show the aggregated values like sum, average, minimum etc currently.
Based on each month to show all year values in one line individually is not available in the line chart now.
Perhaps you can submit the requirement to ideas and add your comments there: https://ideas.powerbi.com/forums/265200-power-bi-ideas
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!
Best Regards,
Yingjie Li
