How to fill different colors in different areas of a shape map;

[Yumikang]

dear, i need heplp:

I am using shape maps, and I have inserted the JSON file according to the map format.

1. I use the “provinces” in the map table as locations in the shape map, which then displays a complete map of China.

2. I treat some provinces in the map table as a large region, so I have a large region table, which is my slicer.

3. I also have a sales table showing the sales of each product in each large region.

My goal: I want to display different colors on the shape map based on different regions; East Region in blue, West Region in green, South Region in pink, North Region in yellow, other regions in orange, and special regions in white;

Can you help me with this?

[v-saisrao-msft]

Hi @Yumikang,

We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.

Thank you.

[v-saisrao-msft]

Hi @Yumikang,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[v-saisrao-msft]

Hi @Yumikang,

Have you had a chance to review the solution we shared by @MFelix ? If the issue persists, feel free to reply so we can help further.

Thank you.

[MFelix · Accepted solution]

Hi @Yumikang ,

For this you need to use the sales value on the tooltips and the colors must be condittional based on the location:

In this small example I have used only New York and California but you can see that they both have different colours.

In your case you need to use the colum of the region to make the color work.