Forum Discussion
Coloring coding in a measure for Map
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, thanks for your reply. I tried the measure you suggested but all the dots appear in grey (including the red ones). I am using the ArgGis map so there is no option in the format pane to set Data colors. Do you have maybe an other suggestion? Thanks!