Issues with scatter chart and slicers

[SPT1992]

Hi,

I'm trying to build a scatter chart off a simple table of Excel data that I have aggregated in a table using Power Query.  The scatter chart looks fine, except that now I want to be able to use slicers on the original table of data to dynamically change the results. I have tried using a measure, which solves the issue of the bubbles not changing in size, but then I have a different issue in that the bubbles are all the same size for each data series.  I'm fairly new to all this and just can't figure it out!

This is what it should look like:

This is what I am getting:

I have uploaded the sample data here:

https://drive.google.com/file/d/16LiQx1IPORHJJttVAvvodfPqJntnkuPW/view?usp=share_link

Thanks for any assistance!

[Anonymous · Accepted solution]

HI @SPT1992,

I think you should change the data type to sum the decimal values. When you use count function, it only gets the value counts and not recognized/aggregate the detailed values.

Regards,

Xiaoxin Sheng