Forum Discussion
Plotting 2 dates from same data table on a line and stacked column chart
How do I plot this on a line and stacked column chart, so the closed date is accurately represented?
When I create it with the open date as the 'shared axis', the prioirty as the 'column series' and the closed date as the 'line value'; the closed date is not being plotted against the month it actually closed because the axis is based on the open date. How do I get around this?
I almsot need to have two axis with some data plotting against the open date and some against the closed.
Here is what the graph currently looks like using my full report but the line series isnt correct.
Thanks
Hi SEliza86
I have created a PBIX file using your data here
https://1drv.ms/u/s!AtDlC2rep7a-oDq7OZESviMpetzu
Basically it uses the data you provided in a table. I then create two relationships to a separate date table. One relationship handles the Opened Date (the default active relationship), while the 2nd relationship handles the count of the Closed date
I use a Month column from the Date table in my axis and plot as per my PBIX file. I hope it makes sense.
12 Replies
- Phil_Seamark
Microsoft Employee
Project number Opened date Closed date Priority 6775 1/06/2017 30/06/2017 3 6776 1/06/2017 30/06/2017 3 6777 1/06/2017 1/11/2017 3 6778 1/06/2017 30/10/2017 3 6779 1/07/2017 30/07/2017 1 6780 1/07/2017 2 6781 1/07/2017 1/11/2017 5 6782 1/07/2017 30/10/2017 4 6783 1/07/2017 30/07/2017 4 6784 1/08/2017 15/11/2017 5 6785 1/08/2017 31/08/2017 3 6786 1/08/2017 1/09/2017 3 6787 1/08/2017 1/09/2017 3 6788 1/08/2017 1/09/2017 3 6789 1/09/2017 1/10/2017 3 6790 1/09/2017 1/10/2017 3 6791 1/09/2017 15/09/2017 2 6792 1/10/2017 30/10/2017 1 6793 1/10/2017 30/10/2017 4 6794 1/10/2017 30/10/2017 4 6795 1/10/2017 15/11/2017 4 6796 1/11/2017 5 6797 1/11/2017 1 6798 1/11/2017 15/11/2017 2 6799 1/11/2017 15/11/2017 3 6800 1/11/2017 15/11/2017 3 6801 1/11/2017 5/12/2017 3 6802 1/11/2017 5/12/2017 3 6803 1/12/2017 3 6804 1/12/2017 3 - Phil_Seamark
Hi SEliza86
I have created a PBIX file using your data here
https://1drv.ms/u/s!AtDlC2rep7a-oDq7OZESviMpetzu
Basically it uses the data you provided in a table. I then create two relationships to a separate date table. One relationship handles the Opened Date (the default active relationship), while the 2nd relationship handles the count of the Closed date
I use a Month column from the Date table in my axis and plot as per my PBIX file. I hope it makes sense.
