Dot/bubble chart with categories in both axis

[JohnDahis]

Good day!

Assuming data like below (and it can be retabulated), what's the Power BI way to produce a chart like the green bubbles'?

I tried "Dot Plot by OKViz" and "Dot Plot by MAQ" but can't use category for the y-axis.

Thank you.

Type	Team 1	Team 2	Team 3	Team 4	Team 5	Team 6
Category 1	9	26	25	21	21	19
Category 2	17	20	5	14	25	25
Category 3	20	22	18	18	8	14
Category 4	6	18	18	15	20	16
Category 5	13	17	21	19	27	5
Category 6	29	13	5	15	29	5

Same data in different form.

Type	Team	Sales
Category 1	Team 1	9
Category 1	Team 2	26
Category 1	Team 3	25
Category 1	Team 4	21
Category 1	Team 5	21
Category 1	Team 6	19
Category 2	Team 1	17
Category 2	Team 2	20
Category 2	Team 3	5
Category 2	Team 4	14
Category 2	Team 5	25
Category 2	Team 6	25
Category 3	Team 1	20
Category 3	Team 2	22
Category 3	Team 3	18
Category 3	Team 4	18
Category 3	Team 5	8
Category 3	Team 6	14
Category 4	Team 1	6
Category 4	Team 2	18
Category 4	Team 3	18
Category 4	Team 4	15
Category 4	Team 5	20
Category 4	Team 6	16
Category 5	Team 1	13
Category 5	Team 2	17
Category 5	Team 3	21
Category 5	Team 4	19
Category 5	Team 5	27
Category 5	Team 6	5
Category 6	Team 1	29
Category 6	Team 2	13
Category 6	Team 3	5
Category 6	Team 4	15
Category 6	Team 5	29
Category 6	Team 6	5

[MAQSupport]

Hello @JohnDahis ,

Currently, Dot Plot by MAQ Software accepts measure on Y-axis.

We have added your request “Support category on Y-axis” to our backlog.

We periodically revisit our published visuals to correct bugs and add enhancements based on user feedback. Once we have an enhancement list set for the next version of this visual, we will let you know on this thread.

If you have an urgent need for this enhancement, please connect to us via our Sales channel.

Thanks again for your feedback, and please continue to provide the same for any of our visuals.

For any further queries or enhancement requests, please contact us at support@maqsoftware.com

Thanks

[Ashish_Mathur]

Hi,

Does this help?  You may download my PBI file from here.  I cannot get the value to appear inside the bubble.

[v-lili6-msft]

hi  @JohnDahis 

To my knowledge, there is no visual could meet your requirment in power bi for now.

As a workaround, you may try this sample.

Regards,

Lin

[Pragati11]

Hi @JohnDahis ,

The GREEN BUBBLE chart in your screenshot looks more like a correlation plot in Power BI. refer the following link:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380814?tab=Overview

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[JohnDahis]

@Pragati11 thank you for your reply.

however it's not - correlation plot refers to the interrelationship amongst the same category. What the green bubbles are of 2 different categories.

[Pragati11]

Hi @JohnDahis ,

One option could be to use Matrix visual with conditional formatting like shown below:

This doesn't give you bubbles but you can use your text columns in Rows & Columns and then put a metric on which you want to compare them in VALUES section.

I will keep digging for bubble chart wit such comparison but for now can only think of this.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[JohnDahis]

@Pragati11 thank you for the comment.

seems it's the best solution to the case. (just btw 🙂 Excel can do a better job with conditonal formatting) 😀