Forum Discussion
Comparing years in line graph
I saw a previous message that was similar to this, but I could not figure out how to get the answer to work at all. I have a dashboard I have made in Excel using a pivot chart from a pivot table....
I only included that query to serve as an example of how I'd approach it so you could see the individual steps. Sorry, I may not have explained that well.
What you need is a 'year' (in your date dimension if you have one) for the legend and something for your X axis like week number.
Are you able to attach a screen shot of your model showing the joins? I might be able to offer better advice if I can see the data model.
I appreciate you helping me out!
Here's a screenshot of the settings for my current line graph.
Let me know if that helps at all.
It's the screenshot of the model that would be most helpful. (and probably the graph)
How does the Power BI version of the graph look right now?