Forum Discussion
Due Date vs. Issued Date Graph
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.
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.
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.
- 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?
- 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?
Hi,
I do not have the file. Please share some data, explain the question and show the expected result.
"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.
