% per country and not in total

[sandb75]

Hello ! 

I'm trying to find a solution but i didn't find it on the forum yet 😞

Basically I have this type of chart (bubble chart) - where the size of the circles represent the number of people.

The problem is that here I have more people in my dataset who belong to the US line or the France line. But the representation here makes some regions for which I have few respondents have small circles.

I would like to know if it is possible for each line that the circle is relative (in %) to the number of respondents of its line (so of it's region or country)

For example if for the first criteria on the x-axis on the bottom left (Functional needs are not covered) I have 5 out of 10 people belonging to the EMEA region, I could have a circle that shows 5 out of 10, more than 5 out of all respondents which is more than 400 respondents (ID).

Thank you in advance 🙂

[sandb75]

Hello dear community,

Anyone has an alternative solution for my issue? 

Thanks a lot !

[v-zhangti]

Hi, @sandb75 

Can you provide some of the example data? And what kind of results you expect to output, preferably with images.

Best Regards

[amitchandak]

@sandb75 , I think you need to try same on charticulator

https://powerbi.microsoft.com/en-us/blog/announcing-the-new-charticulator-visual-public-preview/

Charticulator Part 2 - Scatter with Shapes: https://www.youtube.com/watch?v=QIPsv5hNbqI

Power BI Abstract Thesis Episode 24: Charticulator Part 3 - Circular Visual: https://youtu.be/uOaFyg5GsU8

[sandb75]

Hi amitchandak, i'm really new on PowerBI, so i download the visual type you showed me but can you give me more help on what i need on each field please? Do i need to have measures? thanks