scatter chart

[jtomczyk]

Hi,

Do you have any idea how to create a scatter chart for below data? The axis are not numerical.

I would like to present what is the most common pair of car's engine and car's color.

Scatter chart proposal

Data format

VIN	Engine	Color
AAAZZZ01	1.2 CBZA	Blue
AAAZZZ02	1.2 CBZB	Green
AAAZZZ03	2.0 CBDC	Silver
AAAZZZ04	2.0 CBAA	Black
AAAZZZ05	1.4 CAVD	White
AAAZZZ06	1.6 CAYB	Gold
AAAZZZ07	1.6 BSE	Red
AAAZZZ08	1.6 CAYC	Blue
AAAZZZ09	1.8 CDAA	Green
AAAZZZ10	2.0 CBDC	Silver
AAAZZZ11	2.0 CBAA	Black
AAAZZZ12	2.0 CBDB	White
AAAZZZ13	2.0 CBBB	Gold
AAAZZZ14	2.0 CBFA	Red
AAAZZZ15	2.0 CCZB	Blue
AAAZZZ16	2.0 CDLG	Green
AAAZZZ17	2.0 CBDC	Silver
AAAZZZ18	2.0 CBAA	Black
AAAZZZ19	2.0 CCZB	White
AAAZZZ20	2.0 CDLG	Gold
AAAZZZ21	1.2 CBZB	Red

[v-jingzhang]

Hi @jtomczyk 

I tried the custom visual. Seems if I remove field from Primary Key, the chart displays correctly. I use Count of VIN for Value. 

Best Regards,
Community Support Team _ Jing

[mahoneypat]

Please see this post for how to create a chart with category fields on both X and Y axes.

Solved: Categorical data as X and Y axis - Microsoft Power BI Community

Pat

[jtomczyk]

Hi Pat,

Thanks for prompt reply. I have tried that. Unfortunetly it does not work as I would like.

Here are the screen shot of the chart when puting 

Primary Key VIN

X category Color

Y category Engine

Value VIN

However accoding to the data

Engine 1 with black should have one circle with size 2

Engine 2 with black should have one circle with size 1

Engine 3 with white should have one circle with size 2

Engine 4 with black should have one circle with size 5 and have one circle with size 3

Engine 5 with white should have one circle with size 1 

like that

I have tried to change that but without success... Any idea why it is like that?

Can you please let me know how to edit XYCategory.pbiviz ?