Scatter Chart - bubble size and overlapping

[Anonymous]

Hi,

I'm quite new to Power BI and I am creating a risk map using scatter chart. But I am not really sure if it's the best option.

I am having issue making the size of the bubbles and I would like to see the overlapping bubbles with the same size.

Here is what I have:

Database: Column1          | Column 2 | Column 3         | Column 4                | Column 5

                 Business Unity | Category  | Impact (1 to 5) | Probability (1 to 5)  | Risk ID

                 UA - 01            | Ops          |           3             |              1                | R-6.2_UA-01

                 UA - 01            | Market     |           3             |              1                | R-4.3_UA-01         

                 UA - 01            | Ops          |           3             |              1                | R-6.10_UA-01

                 UA - 02            | Ops          |           3             |              1                | R-5.3_UA-02

                 UA - 01            | Strategic  |           4             |              5                | R-6.2_UA-01      

This is just an example of my database. It goes for 450 rows in total

Risk Map:

X axis: Impact

Y axis: probability

Legend: Category

Size: count number of rows on selected filter. For example: If I filter UA-01, I wanted to see a bigger bubble in Ops (size 2 - 1st and 3rd rows) than in Market (size 1) for the same coordinates (3,1). If I clear all filter, I would see an Ops bubble showing size 3 (1st, 3rd, and 4th rows)

Also, if I clear all filters, I want to see both bubbles R-5.3_UA-02 and R-4.3_UA-01 which are overlapping.

Is there a way I could create this in power BI?

Thanks

[v-lili6-msft · Accepted solution]

HI, @Anonymous

After my test, you could try this way:

Step1:

Set field Impact and Probability Default Summarization: Don't summize

Step2:

Use ISFILTERED Function to add a measure and drag it into Size

Measure = IF(ISFILTERED(Table1[Business Unity]),COUNTROWS(Table1),CALCULATE(COUNTROWS(Table1),ALL(Table1[Category])))

Result:

filter dataclear data

and here is pbix, please try it.

Best Regards,

Lin

[Anonymous]

Hi Lin, 

Thank you very much for your reply.

It didn't work the way I wanted with your mesure, however I made it just dragging the Count Risk_ID into the bubble size
I was trying putting it in details, that's why it was not working,

But I also wanted to see all overlapping bubbles in my chart, even the ones with same size.
For example if I add a row:
UA - 03 | Commercial | 4 | 5 | R2.1_UA - 03

It would be overlapping with the Strategic bubble (R6.2_UA - 01) and the chart I only see one of them.

Is there a way I could see both? I don't know like a pie chart in the bubble spliting the bubble in two colors?

Can I also make the bubble smaller?

Thanks again!

[newpi]

Hi, 

Did you get a solution for overlapping bubbles and how to show them?