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 da...
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

       

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