Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I created a map with pie charts as points but am having trouble making them all one size. There are a few pie charts that are much smaller than the others and I am not sure why?
Is there any way that I can make them all the same size? Or at least individiually change the size of the smaller ones?
Every time I try to make the smaller ones larger in the formatting window, it changes all.
Hi @asanb ,
The size of the pie charts are based on the values for you calculation so the bigger the amount the bigger the bubble.
One option is to create a calculated measure to make the percentage something like:
Pie Map Value = SUM(Table1[Value]) / CALCULATE(SUM(Table1[Value]);ALL(Table1[Category]))
Then use this measure to make your pie charts and on the options Bubbles increase the size of the bubbles, then add the column value to your tooltips.
Check PBIX file attach.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI tried the example measure you had on your map and it didn't seem to work for me. It made other pie charts smaller than the rest. Also what values exactly are making the pie chart smaller? I can't seem to figure out which value is bringing down the size of one of my pie charts.
HI @asanb ,
Can you share a sample file so I test it out?
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi
did you find a solution for this issue?
I am having the same problem with my data, my data is already calculated as a percentage so the pie chart size is supposed to be 100 for every city I am displaying on my map.
Thank you!
Y
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |