Forum Discussion

LaviniaMO's avatar
LaviniaMO
New Member
2 years ago
Solved

Plot a graph with data from 2 different tables in BI (using a calendar table as the x - axis)

Hi guys, 

I wanted to plot a graph using data from two different tables in power bi, but using the same x-axis.

 

On the first table I have the columns [HOURS], [START DATE] and [Bi], that ends at january 2023, whilist in the second table I have the columns [TIME], [DATES] and [Bi], ending at march 2024. What I want to do is creating a graphic where I can visualize the cummulated sum of HOURS and TIME. (As you can see in the picture below, the HOURS column eventualy stops growing as it ends at 2023, while the TIME keeps growing)

I've created a calendar table in which I have dates from 2000 to 2050. I though I could use the [dates] column in this table as the x-axis, by creating a relationship between the tables ([dCalendar] --> [TABLE1] ---> [TABLE2]) however,for some reason the HOURS keep getting represented as if there was data up until 2024. How can I fix this? is there any other way to make this work?

 

Thank you!!

2 Replies