How can I change the data color of a map visual?

[Yonas]

Hi, I am trying to show two colors in a map visual data color, the map is showing number of products by region. My table looks like this

Product              Region             ProductType        Service

Product1             EastUS             Plastic                   Sell

Product2             WestUS            Metal                   Buy

Product1            CentralUS         Plastic                   Buy

Product2             Asia                 Metal                    Buy

all Product1 are plastic and all product2 are Metal.

I have a filter by Service and when i select "Buy" I want to see WestUS and Asia with Red data color(since they have product2 with service buy) and centralUS with datacolor green(since they have product1 with service buy).

something like this

but I cant find the option like that in datacolor section in my map visual.

Any help will be apperciated!! thanks

[parry2k]

@Yonas put product on legend and then you can change the color of product

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Yonas · Accepted solution]

Thank you all for the answers but i have comeup with other ideas by creating a color column in my table for the products and powerbi translates into an actual color...which is impressive.