Forum Discussion

josephmwood's avatar
josephmwood
Regular Visitor
5 years ago

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....
Need Help
josephmwood's avatar
josephmwood
Regular Visitor
5 years ago

Thanks so much! 

 

I did this on my table and it created the new queries and i see them, but they have no effect on my table right now. I tried creating relationships between the date and my tables, but it doesn't do anything. Do I have to customize your code to fit with my tables and correct column names that I'm pulling from my server? I'm using several different sections of a server to bring information together.

KNP's avatar
KNP
Super User
5 years ago

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.

  • josephmwood's avatar
    josephmwood
    Regular Visitor
    5 years ago

    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.

    • KNP's avatar
      KNP
      Super User
      5 years ago

      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?