Forum Discussion
Change scatter plot - categorical count change
Community SupportHi Anonymous
Can you provide some sample data without sensitive data? The X and Y axis fields should be the same column in a table and be non-aggregated, right? And the value should be count of rows that match the X-Y pairs?
Best Regards,
Community Support Team _ Jing
Hi v-jingzhang ,
A simple dataset and desired result in Power Bi would be as follows in which x axis is then 'Status_0' and y axis 'Status_1':
| Participant | Status_0 | Status_1 |
| A | 1 | 3 |
| B | 2 | 3 |
| C | 1 | 1 |
| D | 3 | 2 |
| E | 1 | 2 |
- v-jingzhang
Hi Anonymous
Select Don't summarize for both Status_0 and Status_1. Put Participant into Size well and select Count for it. You can change the marker size and axis range in Format pane.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.Thanks, that worked for numerical values in Status_0 and Status_1. Now if I try it with a dataset in which both statuses are text being the categories, I get the following:
What would be a workaround to solve this?
- v-jingzhang
Hi Anonymous
Well, the current scatter chart doesn't support that. Maybe you can use Charticulator to create a custom visual or use SandDance.
Based on my test, SandDance supports text-type fields on X/Y axis.
Here is a video sample with Charticulator. I haven't tried it yet.
Excel vs Power BI: How to create a scatter chart with text axis custom visual - YouTube
Best Regards,
Jing