Forum Discussion

asanb's avatar
asanb
Frequent Visitor
7 years ago

Pie chart map - charts are different sizes?

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...
Need Help
Show and Tell
Tutorial Requests
MFelix's avatar
MFelix
Super User
7 years ago

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

asanb's avatar
asanb
Frequent Visitor
7 years ago

I 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. 

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    HI asanb ,

     

    Can you share a sample file so I test it out?

     

    Regards,

    MFelix

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi

      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