Forum Discussion
Solved
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...
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.
Phil_Seamark
Microsoft Employee
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 |