Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ssstaud
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
ssstaud
Frequent Visitor

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
ssstaud
Frequent Visitor

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.

v-qiuyu-msft
Community Support
Community Support

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.