Forum Discussion
Scatter Chart - bubble size and overlapping
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
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
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!
Hi,
Did you get a solution for overlapping bubbles and how to show them?