Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
Can you please explain with an example or a chart. If possible please share a sample pbix file after removing sensitive information.
Thanks
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,
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.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |