Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |