Power BI world map highlight countries

Question

I have data from excel for a test. like this:

Country Sales
NL       5000
BE       10000
DE       500000
US       50

so I want to to mark country with highest sale value green and lowest with red. Right now it shows this: enter image description here

is is possible to highlight the whole country so not just a circle but make like a box in the country regions across the country border?

Answer 1

With a custom map specification and a shape map visual component, you should get the following result:

1) Get the JSON file for the World Countries Map. 2) On the report page, drop the Shape Map component. Select the world-countries.json file you downloaded in step #1 from the Format section / Shape / "+ Add map" button.

"Format section / Data colors" 3) Trun "Diverging" (if necessary): "Format section / Data colors" 4) Remove the Country field from the Location portion of the graphic and the Sales field from the Color Saturation section.

If you are interested in learning Power BI, then check out Power BI Online Training now!