Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
82 | |
64 | |
63 | |
56 |
User | Count |
---|---|
171 | |
113 | |
110 | |
73 | |
73 |