Linear bubble chart

[joshua1990]

Hi experts!

I'm trying to get a kind of linear bubble churt that shows mit per category and area the number of sales based on the bubble size.

The area is like "Peaches, Apples..." and the category is on the y axis.

Example see below

The current structure of the table is like that:

Area	Category	Value
SW	A	21
SW	B	0
SW	C	0
SW	D	0
PL	A	21
PL	B	0
PL	C	0
PL	D	0
EL	A	5
EL	B	6
EL	C	4
EL	D	6
GT	A	8
GT	B	7
GT	C	6
GT	D	0
MS	A	19
MS	B	1
MS	C	1
MS	D	0

How is this possible in Power BI?

[SpartaBI]

@joshua1990 take a look at some of the free custom visual bubble charts that has also categorical no both axis (The built in can only have category on the X axis).
https://appsource.microsoft.com/en-us/marketplace/apps?search=bubble&page=1
I tried to play now with some, it can be done but the formating options are not so rich for the one I saw. Didn't check all of them.

Showcase Report – Contoso By SpartaBI