Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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-...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
ThomasWeppler
Icon for Impactful Individual rankImpactful Individual
3 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.