Forum Discussion
Enhanced Scatter plot - using count instead of values
I'm trying to use the enhanced scatter plot to visualize a really simple excel table, but when adding the values to the X and Y axes, then it takes either the count or the summation and not the data values. I have checked my data of numeric type and when using the normal scatter plot it shows the data correctly. what could be wrong here ?
Hi, AhmadZnait
According to your description, you want to implement the effect of not summarizing the X and Y axes of the Enhanced Scatterplot, after my testing, it is true that you can't achieve the effect you want, the fact that the X and Y axes of the Enhanced Scatterplot usually need to summarize the data imposes a limitation on this functionality, you can submit an idea for here and the product team will take note of such a need.
Related Link: New tab (powerbi.com)
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
2 Replies
Hi, AhmadZnait
According to your description, you want to implement the effect of not summarizing the X and Y axes of the Enhanced Scatterplot, after my testing, it is true that you can't achieve the effect you want, the fact that the X and Y axes of the Enhanced Scatterplot usually need to summarize the data imposes a limitation on this functionality, you can submit an idea for here and the product team will take note of such a need.
Related Link: New tab (powerbi.com)
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi all,
I too have the same problem. The x-axis shows the date. Why does PowerBi count the rows on the y-axis instead of showing the value.
The checks I have done 1. no double date. 2. i have the correct datatype (decimal) 3. in the powerquery the correct dimension is there (sigma sign is there).
But as soon as I set Dont summarize the y-axis value changes to Count. The table visual does show the values.
Need some help please.