Map not aggregating in the right way

[EnriquePeña]

Hi.

I need to make a map showing category sizes in "pie chart like" bubbles, for each country. The total sum of categories for each country, is the same, so all bubbles should have the same size. But that is not happening. Strangely some locations have bigger size than others, with no explainable reason:

This happens even if I remove the category field from legend, and even if I turn values to whole numbers (in Format, in Data mode):

Yes: now each bubble has a value of 1.000. But only Spain is smaller than the other countries.

When I use a matrix to show the data everything is ok:

If I modify the format of the field to have 15 decimals, then, weird things happens:

And that number, in the data mode:

1. Why maps are not respecting the format specified for the column? (tooltip is OK; the wrong thing is the number used in the size calculation)

2. Why maps are not aggregating right? Is this a bug?

Thanks a lot, in advance. Enrique Peña.

[v-chuncz-msft]

@EnriquePeña 

You may try converting data type to Fixed Decimal Number.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types

[EnriquePeña]

@v-chuncz-msftworked with my workaround data (whole-d numbers) but not with the original ones. Also worked when converting to whole numbers in the query editor.

With the original data, it keeps happening the same:

And when I look the data at the matrix:

Looks fine. Let's put some more decimals:

Again is wrong. This happened with 2.93.641.0 and with 2.93.981.0 versions.