Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Scatter Chart - bubble size and overlapping

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
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

     

     

     

     

     

     

     

     

3 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        newpi
        Helper V
        6 years ago

        Hi, 

         

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