Create a simple date graph

[Anonymous]

Hello everybody,

I would like to create a simple line graph where I have dates on the X-axis and the cumulative number of diffusion dates and the cumulative number of expected diffusion dates on my Y-axis.

I have created a date table with the formula Calendar = CALENDARAUTO() for my X-axis.

For the Y-axis, I have a table with the real diffusion date and the expected diffusion date for each document (no diffusion date if no diffusion). I expected to see the progression of the number of diffusions.

For a reason I don't get, the graph shows only the total number of diffusion date and the total number of expected diffusion date I have in my table.

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Download sample PBIX file with this data/chart

You need to rearrange your data so that the Y-axis is plotting numeric values rather than dates.  Something like this

You can then plot this chart with Real/Expected as the Legend

Regards

Phil

[Anonymous]

Thank you, it seems to solve my problem !