Two dates on the x-axis. Dual x axis chart

[anansrivastava]

I have 2 date columns - planned date and actual date. I need to plot their values on a single combo chart - 

How can I show this together on 1 graph?

Planned date graph - 

Actual date graph - 

 I would like to get these 2 graphs on 1 graph. But since the axis for these are different (different date columns), I can't do it. Any help is much appreciated.

@amitchandak amitji if you can help with this one

[gdarakji · Accepted solution]

You need to create a dimention table and relate it to the Actual and Planned tables. You can follow the below steps and refer to the sample pbix provided on https://1drv.ms/u/s!AgAlCRkx-ILRgxYunNQgJGUBEe9B?e=0dOoHk:

1. Add a date column to the Actuals and Planned tables by using the existing Year and Month columns
2. Create a Dates table along with columns for Year, Month, and Day
3. Relate all tables as shown below