Forum Discussion
Due Date vs. Issued Date Graph
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
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.
8 Replies
Can you please explain with an example or a chart. If possible please share a sample pbix file after removing sensitive information.
ThanksHi,
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.
