Forum Discussion
Coloring coding in a measure for Map
Hello everyone,
I have been working on a PowerBi dashboard with finctional sales data of pharma companies between 2017 and 2020 for a Uni Project. I have created already quite some visuals and working now on a map. For this I want to color the geographical dots green and red based on a measure and tried therefore to create a new measure for the color. However, when I put "green", the dots appear blue. I have tried to use color code like "#2FF383" but it just appears in grey. Conditional formatting on the field directly is not possible for this visual, so it has to be through an extra measure.
I would appreciate any kind of help, thanks!
3 Replies
hi Anonymous ,
ArcGIS Maps in Power BI don’t support dynamic or DAX-based coloring (like mapping a measure to HEX codes or names). The only way you can set colors in this visual is by assigning a category (like “Good”/“Bad” or “Active”/“Inactive”) and then manually picking the color for each category in the visual’s Symbology (paint roller) settings.
How to make it work:-
Create a new column or measure that labels each data point by your rule, for example: If [KPI_switch_Dist] = 1, label as “Good”. If [KPI_switch_Dist] = 0, label as “Bad”
-
Add this field to the Category well in the ArcGIS visual.
-
Go to the paint roller (Symbology) options in the ArcGIS visual and assign your desired colors for “Good” and “Bad.”
If truly dynamic coloring is a must, consider using the standard Power BI Map or Shape Map visual instead—those do support “Data colors” that you can tie directly to your DAX logic. Red and green is a tricky combo for color-blind users consider blue/orange or blue/purple as an alternative if accessibility is a concern.
-
Hi Anonymous,
I have tested your measure and your DAX is perfectly valid.
I think the color deviation might be caused by either the color calibration of your monitor or a color blindness setting in your operating system.
One final suggestion: red and green is a notoriously bad color combination for most types of color blindness. Have a look at this blog for inspiration.
Best of luck.
