Forum Discussion

SEliza86's avatar
SEliza86
Frequent Visitor
8 years ago
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...
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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.

juliarwk's avatar
juliarwk
Frequent Visitor
4 years ago

Thank you so much, I have been looking for hours for this solution!!