Forum Discussion
Dates on vertical axis?
may be, you can try custom visual Advanced Line Chart ?
Impactful IndividualOk 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?)
- 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.
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.