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

[LaviniaMO]

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!!

[The8 · Accepted solution]

Hello @LaviniaMO 

Do through link below

https://drive.google.com/file/d/1XrhH8JpZ1b5CeEF4Bzujr4rgt7U8flGL/view?usp=drive_link

Try with your data and let me know.

[ToddChitt]

Can you share a screenshot sample of your data from the tables in question? Also a screenshot of the relationship between them.

What is column [Bi]? What is column [TIME]? Is it the time of day? Are you dealing with DATE data type in the columns that form the relationships?