Dates on vertical axis?

[hulsbergenw]

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

[radhey_rec · Accepted solution]

may be, you can try custom visual Advanced Line Chart ?

[hulsbergenw]

Yes that worked! Too bad it isn't native PBI, while Excel doesn't even blink to perform this trick.

[ThomasWeppler]

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?

[hulsbergenw]

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 @hulsbergenw 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.

[hulsbergenw]

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?)

[ThomasWeppler]

You can edit the x-axis and y-axis by pressing the diagram and pick format visual.

Here you have a lot of options to edit the x-axis I think the best way to solve it is just to play a bit around with the options.

[hulsbergenw]

I've tried it all, but Power BI just isn't capable of formatting a y-axis as date. A custum graph did it in the end.