Line Chart - Two complementary date axis

[GregoryMartin]

Hello there,

I tried to solve this problem by myself but I'm quite a beginner on Power BI Desktop and my knowledge are limited so here I am.

I've got in my DB two columns with values I try to join together. In the first table, I've got production values and in the second one I've got production expectation values. Each table contains date reference for values. The production table contains dates from past to today and the expectation table contains dates from today to 20 years forward.

I want to have on the same line chart values from these two table with the date on x axis. It could help my users to comparate actual production to expectation. But now, I can't have those two fields 'date' on the same line. When I try to do this, each one is creating its own x axis.

Have you got some magic tricks in your hat to help me ?

[jthomson · Accepted solution]

---

@GregoryMartin wrote:

The two table are completly seperated. No date table between them. I have only reading rights on the DB so I can't do any views or any structural change. Every I can do is via Power BI.

---

You can make one of these in Power BI using the CALENDARAUTO function, or by throwing one together in, say, Excel and importing it from there (plenty of options on how to do this from a quick Google). Once you've got that in place and relationships between it and your two tables, you should then be able to get your one single time axis

[jthomson]

Are the tables connected by a date table?

[GregoryMartin]

The two table are completly seperated. No date table between them. I have only reading rights on the DB so I can't do any views or any structural change. Every I can do is via Power BI.

[jthomson · Accepted solution]

---

@GregoryMartin wrote:

The two table are completly seperated. No date table between them. I have only reading rights on the DB so I can't do any views or any structural change. Every I can do is via Power BI.

---

You can make one of these in Power BI using the CALENDARAUTO function, or by throwing one together in, say, Excel and importing it from there (plenty of options on how to do this from a quick Google). Once you've got that in place and relationships between it and your two tables, you should then be able to get your one single time axis

[GregoryMartin · Accepted solution]

@jthomson

I didn't see CALENDARAUTO() function. You kinda save my life. Thank you so much.