Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 thei...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    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.

amitchandak's avatar
amitchandak
Super User
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Ashish_Mathur
      Super User
      6 years ago

      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's avatar
        aliciadeak
        New Member
        2 years ago
        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?