Show grouped data with thresholds on map

[Anonymous]

My question is very specific. I find answers to every partof my question, but not the combination of it all.

So, I want to visualise the prevalence of a disease in certain areas in the world and have different colors if the prevalence exceed certain thresholds. I know how to do this (via Data colours > Advanced controls and using rules).

I want the data to be grouped in regions that I have set up. Also that I know how to do (via creating a group of the countries).

When I put these groups on the map, it is not recognized, so nothing is shown (which I find somewhere logical, but it's not what I want :-)). When I use the countries instead of the groups, the color coding is properly done on the map, only the prevalence of the individual countries is taken into account and not of the grouped region where that country is in.

I want to show the prevalence of the complete region on the map with the countries that are part of that region colored in the same color (depending on the threshold). For example region RESU contains Belarus, Georgia, Kazachstan, Russian Federation and Ukraine. Suppose that the prevalence in this region is 30% (I have defined a measure that counts the positive cases of my complete dataset divided by the total. So when this measure is thrown on the map together with countries the percentage is correctly split out over the countries. But I want it to be split out over the regions only. So in this case I want to see all the countries of the RESU region colored light red with 30% in the tooltip of each country (that is the color of the threshold 25% that was exceeded).

I hope my explanation makes sense 🙂

[v-danhe-msft]

Hi @Anonymous,

Based on my test, you could refer to below steps to show the dynamic data:

Sample data:

Create below measure:

Percentage = CALCULATE(SUM(Table1[Value]))/CALCULATE(SUM(Table1[Value]),ALL(Table1))

Color rule = SWITCH(TRUE(),[Percentage]<=0.2,"#01B8AA",
                          [Percentage]<=0.3,"FD625E","A66999")

Set the Advanced Controls for your data color:

You could also download the pbix file to have a view.

Regards,

Daniel He

[Anonymous]

Hi, thank you for your help!

This gives me the same result as what I get with using the map formatting by rules. The problem is that I want to see the colouring based on the regions that I created, where the percentage of the individual countries in every region together is calculated --> so , 1 percentage for 1 region --> all countries in this region have the same color and percentage on the map.

I believe that the biggest challeng here is to make the map know what countries are present in the regions I created so that these can be colored. Because now, when I group the countries to a region and I drage the regions on the map, it is not recognized and nothing gets colored.