Due Date vs. Issued Date Graph

[DominicB1990]

Hi,

I'm looking to compare due dates vs. issued dates on a line graph (or open to any other suggestions). I essentially want to visually display how we are performing by issuing items before their due date. This graph only needs to show 1 years worth of data as each item is only due once per year.

Currently the data I have is:

Column 1 - Items (31 in total)

Column 2 - Due Date (DD/MM/YYYY)

Column 3 - Issued Date (DD/MM/YYYY)

Using this data in Power BI, I cannot get it to work even trying multiple different ways. Currently i'm just getting no data on the line graph and just a Key at the top with the item names.

Any help would be much appreciated.

Cheers,

Dom

[amitchandak]

Can you please explain with an example or a chart. If possible please share a sample pbix file after removing sensitive information.
Thanks

[DominicB1990]

I'm not too sure of the best way to display the data, very much open to suggestions. I managed to create this one in Excel but think there's definitely better ways to display it and I also can't figure how to duplicate it in Power BI.

[Ashish_Mathur · Accepted solution]

Hi,

I don't think we can plot Dates on the Y axis.  Therefore, i converted the dates to numbers, hid the Y axis and create a tooltip to show the 2 dates per category on mouse hover.  You may download my PBI file from here.

Hope this helps.

[aliciadeak]

Hi Ashish, This is an older thread but exactly what I am looking for. The file link no longer works. Would you be able to post an update? Could you tag me in it?

[Ashish_Mathur]

Hi,

I do not have the file.  Please share some data, explain the question and show the expected result.

[aliciadeak]

"I don't think we can plot Dates on the Y axis.  Therefore, i converted the dates to numbers, hid the Y axis and create a tooltip to show the 2 dates per category on mouse hover.  You may download my PBI file from here.

Hope this helps."

If you no longer have the file - a lot has happened since 2019 ha! then that is okay. I came up with the plan to convert my dates and hide as well, i am having trouble getting the two lines to show up at the same time since they use different values. but the image does help. 

[aliciadeak]

Hi Ashish, This is an older thread but exactly what I am looking for. The file link no longer works. Would you be able to post an update? Could you tag me in it?

[DominicB1990]