Forum Discussion
Dates on vertical axis?
may be, you can try custom visual Advanced Line Chart ?
Impactful IndividualI think you need to explain a couple of things about the graph.
1. What does the y-axis show?
2. What does the x-axis show?
3. What does the three diffrent lines show?
1. The y-axis shows the deadlines in time
2. The x-axis shows the report-dates
3. The lines are the different milestones, shown in the third column.
So for example, Milestone "VO" is stable, it was predicted to be "25-02-2022" in the first report on 24-12-2021, and hasn't moved since. However Milestone "TO" was planned at "25-07-2022" in the first report, but has shifted backwards significantly and was planned at "28-04-2023" in the report of 30-01-2023
- ThomasWeppler
Ok Anonymous I think you might have some follow up questions to this answer although some of it you can solve with the help of google.
1. I would import the tabel you have to a power BI report
2. I would add a calender tabel to you power BI report
3. I would create a connection between the date report and the in the calender tabel.I would make a line chart with date from the calender tabel (month-year) in x-axis, the reporte date in y-axis and the data from colum with diffrent milestones in Legend.
I hope this will get you in right direction.Thanks for helping. I have tried all this. There seems to be a fundamental difference between PBI and Excel, I get the following error:
It appear that PBI requires one of the axis to be numerical and can't handle the date value as such. So a measer like MAX(Date Milestone) doesn't work.
In the end I kind of got it working by adding an index per Report date and using the XY-scatter. However the y-axis looks weird and no lines.
(Can I upload PBIX-files?)