Time series as shared axis

[Anonymous]

Hello Everyone, I'm facing a problem into Power BI and I hope some of you could help me.

I'm trying to do a graph with line and columns like this one:

The problem is a have to choose which date put on X axis. My data set is like the one below:

If I put the Planned dates as the shared x axis, my actual date will appear on the planned date and I would like the actual appears at actual date. I did in Excel to show you how it should appear:

Thank you everyone.

Regards

[mwegener]

Hi @Anonymous ,

link all data fields with a date table.

Create a measure for each date and activate the corresponding relationship with USERELATIONSHIP.
Place the date table on the axis.

https://docs.microsoft.com/en-us/dax/userelationship-function-dax

If you provide some sample data, I can build an example for you.

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[Anonymous]

Hi @mwegener ,

First of all, thank you very much repplying me.

I'm sharing with you one data set that I'm trying to do this kind of graph without success. (https://1drv.ms/x/s!Am9o_aLPkoYukuMziXNWkZLDwIkTJw?e=8btMoA)

I appreciate all help or any kind of tip toward the solution.

Thanks

Regards

[mwegener · Accepted solution]

Hi @Anonymous ,

check this out.

PBIX

Some dates were inconsistent.
These lines were ignored.

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[Anonymous]

Thank you very much @mwegener 

Really helped me.