Forum Discussion
Scatter Plot Not working as should!
Hi,
I want my scatter plot to show all values, however I am getting this error:
In the Y axis, I am clicking on Do not summarise which causes this. I do not want to sum or find the average, I just want all the values to be displayed. The X axis is a date column.
My table looks like this:
Where am I going wrong?
Much appreciated in advance!
Hi imo3220
There is a known issue to handle with it, you can add an index column from the Power query and use as level of hierarchy or as a legend.versions of results:
The aggregation is still showing all points because of "repeating dates"
Pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
1 Reply
- Ritaf1983Super User
Hi imo3220
There is a known issue to handle with it, you can add an index column from the Power query and use as level of hierarchy or as a legend.versions of results:
The aggregation is still showing all points because of "repeating dates"
Pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly