Date on y-axis

[Anonymous]

Hey Community, 

I am trying to build an dashboard to watch our production. We already realized it with Excel as you can see in the attached image. What I would like to see in the graph is the difference between the planned-process and the target-process, so an evaluation of production orders. Now I am trying to realize it in PowerBI but I am not able to put the date on the y-axis and the procedure-numbers on the x-axis. 

In Excel I already had to "fake" the data and choose the "minimum of target-date", otherwise excel always wanted to "sum" or "number of.." the dates. 

Hope you can help me, already searched a lot but never found someone with the same problem.

Thank you!!

 

10	01.01.2021	01.01.2021
20	02.02.2021	02.02.2021
50	05.01.2021	06.01.2021
60	06.01.2021	08.01.2021
740	07.01.2021	22.01.2021
990	10.01.2021	22.02.2021

[Anonymous]

@amitchandak thank you for your answer! I alreday expected something like that and already searched for some custom visuals but did not found anything. So there is no other option? 

[amitchandak · Accepted solution]

@Anonymous , In power bi you can not have columns in both axis. Check for some X-Y visual in custom visual

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

[Anonymous]

Just found this one for anybody who has the same struggle:  Plotting dates on Y axis 

Thanks.