Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I created a simple table which I converted into a scatter chart. The problem is that much of the data that can be seen in the table is not shown in the scatter chart. i.e. the table shows 17 people with an Activity Score over 80 that also have an Average Test Score. When I switch it to a scatter chart only one of these is represented (Activity Score 84.4, Average Test Score 93.0). Where might the other 16 have gone? Could it be there is too much data in the table (23,748 people)?
Thank you in advance for your help.
Best,
DHB.
Solved! Go to Solution.
Hi @DHB,
Could it be there is too much data in the table (23,748 people)?
Yes, it should be the cause.
In this scenario, you may need to pick a category that doesn't have too many values.
According to this article, if the category has more than 2,000 values, you see a note that the chart is “showing representative sample” rather than all the categories. Really, it's hard to see individual bubbles if you have a lot of them.
Regards
Hi @DHB,
Could it be there is too much data in the table (23,748 people)?
Yes, it should be the cause.
In this scenario, you may need to pick a category that doesn't have too many values.
According to this article, if the category has more than 2,000 values, you see a note that the chart is “showing representative sample” rather than all the categories. Really, it's hard to see individual bubbles if you have a lot of them.
Regards
Thanks for your reply. It's good to know I wasn't doing something wrong.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |