Forum Discussion
Dates on vertical axis?
I have a graph in Excel where you can see the shifting of deadline-dates over time. How do I recreate it in PBI?
| Date Report | Date Milestone | Fase |
| 24-12-2021 | 25-2-2022 | VO |
| 24-12-2021 | 6-5-2022 | DO |
| 24-12-2021 | 15-7-2022 | TO |
| 15-3-2022 | 25-2-2022 | VO |
| 15-3-2022 | 6-5-2022 | DO |
| 15-3-2022 | 15-7-2022 | TO |
| 18-3-2022 | 25-2-2022 | VO |
| 18-3-2022 | 13-5-2022 | DO |
| 18-3-2022 | 22-7-2022 | TO |
| 15-4-2022 | 25-2-2022 | VO |
| 15-4-2022 | 24-5-2022 | DO |
| 15-4-2022 | 16-8-2022 | TO |
| 16-5-2022 | 25-2-2022 | VO |
| 16-5-2022 | 20-6-2022 | DO |
| 16-5-2022 | 29-8-2022 | TO |
| 15-7-2022 | 25-2-2022 | VO |
| 15-7-2022 | 22-7-2022 | DO |
| 15-7-2022 | 30-9-2022 | TO |
| 14-9-2022 | 25-2-2022 | VO |
| 14-9-2022 | 22-7-2022 | DO |
| 14-9-2022 | 11-11-2022 | TO |
| 25-10-2022 | 25-2-2022 | VO |
| 25-10-2022 | 22-7-2022 | DO |
| 25-10-2022 | 10-3-2023 | TO |
| 11-11-2022 | 25-2-2022 | VO |
| 11-11-2022 | 22-7-2022 | DO |
| 11-11-2022 | 13-4-2023 | TO |
| 5-12-2022 | 25-2-2022 | VO |
| 5-12-2022 | 22-7-2022 | DO |
| 5-12-2022 | 13-4-2023 | TO |
| 11-1-2023 | 25-2-2022 | VO |
| 11-1-2023 | 22-7-2022 | DO |
| 11-1-2023 | 28-4-2023 | TO |
| 30-1-2023 | 25-2-2022 | VO |
| 30-1-2023 | 22-7-2022 | DO |
| 30-1-2023 | 28-4-2023 | TO |
Update: Added info:
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
may be, you can try custom visual Advanced Line Chart ?
15 Replies
may be, you can try custom visual Advanced Line Chart ?
Hi
i am looking for the same solution can you please please provide the solution howyou achived itThanks In advance
I 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
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.
I have tried this but am still unable to get dates on the axis
can anyone help me with this, I was trying to plot a line graph and try to do the same
im really shocked to see powerbi as top BI tool surpassing tableau, with so much of limitations, while in tableau we can do so much custom work no limitation, now i really doubt the ranking of BI tools in magic quadrant chart.
