Forum Discussion

anansrivastava's avatar
anansrivastava
Frequent Visitor
5 years ago
Solved

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

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

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

       

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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