Forum Discussion
Scatter Chart - Excel can do it, why cant PowerBi?
Hi guys,
I've been trying to recreate this "lovely" distribution visual in PowerBi, but the PBI scatter chart isn't playing ball.
Each dot represents a unique client.
Axis Y represents the time lapse from arrival to departure
Axis X represents date of departure
Depressingly, Excel does it in a blink of an eye, whilst PowerBi struggles here and insists on summarisation of Y, which is not what I am trying to achieve.
Can anyone suggest a workaround please? Is it possible to get the same result in PowerBi?
Thank you
2 Replies
JckPlck , add an index column (row id) to you table in power query and use that as details. Now you can use sum([lead time]) measure on y axis
Power Query- Index Column: https://youtu.be/NS4esnCDqVw
Hi amitchandak , thank you for your response.
Sadly, this hasnt worked for me. I tried another solution that I found online and got fairly close to the results I am after, but not exactly. The axis X is generated on the fly using RAND() function, which means the data points appear randomly along axis X which isnt ideal.
Im half way there I think, not sure how to fix the axis X....
