Change scatter plot - categorical count change

[Anonymous]

When trying to recreate below change scatter plot in Power Bi using the scatter chart I can't seem to figure out how to add the same categories in the y axis to compare the movements between categories between two points in time.

Basically the chart should show the count of lines in the dataset within category x axis that 'moved' to or remained in same category at another point in time being represented by the y axis. Both datapoints are included in the same dataset.

  

[v-jingzhang]

Hi @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

[Anonymous]

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.

[Anonymous]

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