Forum Discussion
Create a simple date graph
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.
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
2 Replies
- PhilipTreacySuper User
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
- AnonymousNot applicable
Thank you, it seems to solve my problem !