Multiple X-axis/Time Data in Line Chart/LineDot Chart

[CZGruezimek]

Hello everyone, I have the following challenge in Power BI:
I would like to display the following table data in a chart so that I can compare them. “Date 1” and the associated “Price 1” should be displayed as a line, “Date 2” and the associated “Price 2” as data points.

Data example:

Date 1	Price 1	Date 2	Price 2
01.01.2017	525.422,26	13.12.2017	530.000,00
01.02.2017	525.422,26	23.11.2020	600.000,00
01.03.2017	525.422,26	25.11.2020	600.000,00
01.02.2018	539.155,47	21.08.2023	665.800,00
01.03.2018	539.155,47	08.08.2023	663.700,00
01.04.2017	546.276,39	08.08.2023	668.900,00
01.05.2018	546.276,39	08.08.2023	663.700,00
01.06.2018	546.276,39	30.08.2022	680.000,00
01.07.2018	546.276,39	01.10.2022	680.000,00
01.08.2018	546.276,39	23.08.2022	680.000,00
01.09.2018	546.276,39
01.10.2018	546.276,39
01.11.2018	546.276,39
01.12.2018	546.276,39
01.01.2019	556.449,14

I achieved the final aspect in Power BI by reducing the line width in a line chart and using data markers.
But now I have the problem that Price 1 and 2 each have different associated time data... conversely, I have two X-axes. 

Excel chart example:

As can be seen in the Excel diagram shown, this representation is possible in Excel, but so far I have not found a way to integrate "Date 2" in Power BI and display it correctly. I would be very happy about a tip. Thanks.

[Ritaf1983 · Accepted solution]

Hi @CZGruezimek 
You can use a date table with an active relationship to date 1 and inactive to date 2,
And use a function use relationship for calculating price 2.

Pbix with example is attached

More information about handling multiple dates on the link:
https://www.youtube.com/watch?v=fOcgIuaJHEs&t=39s

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[CZGruezimek]

Hi @Ritaf1983  
Thanks for your reply! Unfortunately it doesn't work yet.
I would be happy if you could help me again.
Here's what I've done so far:

Here is my formatted data base again:

As shown in this video, (https://www.youtube.com/watch?v=5i41-FiscYI) I disabled the Auto Date Time. I then created a Date Table using Power Query. As you showed, I then created the links between "Table" and "calender", as well as the measure "price 2_".

Then I dragged the measure into the Y-axis (as shown in this video https://www.youtube.com/watch?v=fOcgIuaJHEs&t=39s). Unfortunately, the following illustration emerged:

Thanks!

[Ritaf1983]

Hi @CZGruezimek 
please share a link to pbix I'll try to help

[Ritaf1983]

Hi @CZGruezimek 
1. I added missing dates to the date table that you created. 

2. You need to use a date from the date table as a graph axis.

3. the last price_1 is in December 2019 so its line ends there...

The updated pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[CZGruezimek]

@Ritaf1983Thank you very much for your help! That's how I wanted it 🙂

[Ritaf1983]

Happy to help, you were on the right way 🙂