cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ssstaud Frequent Visitor
Frequent Visitor

Line graph not working with multiple years

Hello,
I have been clueless about how to do basically this graph in power BI. 

I have divided the data set to two different years. As a X axis I put: date hierarchy->month (from the 2015 category)
When I input the data from the same year (=same category) everything is fine. The problem is when I input  the values from the different year, the values are all the same for all months and much higher than they actually are. 

Here is a screenshot how it looks like.

https://imgur.com/a/y5jWSxA

Could anyone tell me what am I doing wrong?

I have just started with power BI so please bear with me 🙂

 

1 ACCEPTED SOLUTION

Accepted Solutions
ssstaud Frequent Visitor
Frequent Visitor

Re: Line graph not working with multiple years

soooo I figured it out. 
When you compare the same data you actually have to use measures in the table to compare them. 
https://www.youtube.com/watch?v=JNt-_QByeLk
This video shows it nicely.

View solution in original post

2 REPLIES 2
Moderator v-qiuyu-msft
Moderator

Re: Line graph not working with multiple years

Hi @ssstaud ,

 

From the screenshot, it looks like the the column [starttype] and [usertype 2015] from the table 2015, while [usertype 2016] from the table 2016, right?

 

As the [usertype 2015] display corresponding values for each month but [usertype 2016] display the same value for each month, I guess there isn't any relationship between tables 2015 and 2016 then cause this this issue. Please follow this article to create a relationship between these two tables then test again: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ssstaud Frequent Visitor
Frequent Visitor

Re: Line graph not working with multiple years

soooo I figured it out. 
When you compare the same data you actually have to use measures in the table to compare them. 
https://www.youtube.com/watch?v=JNt-_QByeLk
This video shows it nicely.

View solution in original post

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 71 members 1,061 guests
Please welcome our newest community members: