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

In the Query Editor, you can transform the column to be Date rather than DateTime.  There should be a button called "Date" where you can choose a "Date only" option.  This will strip away the hours, mins and seconds

SEliza86's avatar
SEliza86
Frequent Visitor
8 years ago

Thanks Phil. I've learned heaps and all my reports are now working as intended.