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.

SEliza86's avatar
SEliza86
Frequent Visitor
8 years ago

They're not important.

What's the quickest way to convert the column to just DATE?

 

Thanks!

SEliza86's avatar
SEliza86
Frequent Visitor
8 years ago

I should add, that changing the format of the dates to just DATE from DATETIME in modelling hasnt changed the output of the graph. Its still just one big column not showing movement over the previous months.