Color My World

[Anonymous]

I have made this table to color the dots on the map I have created.

However, the colors that are shown on the maps are not the same ones that are specified in the hex codes:

Property Type	Color code	Color I am Exoectubg	Color on Map
Leased	FF0000	Red	Green
Owned	0000FF	Blue	Purple
Commercial Morgtage	00FF00	Green	Blue
Auto	00FFFF	Cyan	Red

Please help me fix this problem.

[HashamNiaz]

Hi !

Please share the Data Model diagram, seem you are using another table which has fact information & that is mapped to status table.

In Power BI - Map chart, go to format, expand Data colors -> press (fx) and use format by [field vaue] to provide data fill colors.

Data ColorsData Colors2

Regards,

Hasham

[Anonymous]

Here you go.  I don't see a problem with the data model, though...

[HashamNiaz]

Hi !

Thanks, the model diagram will help us understand how you are plotting the map chart.

You can create a measure lie below;

Property Color = SWITCH( TRUE(),
                MAX(Property Type[Property Type]) = "Leased", 1,
                MAX(Property Type[Property Type]) = "Owned", 2,
                MAX(Property Type[Property Type]) = "Commercial Mortgage", 3,
                MAX(Property Type[Property Type]) = "Auto", 4,
                5
)

Now, in the Data Color option, choose format by Rules as shown below;

Colors3

Hope this will work for you.

Regards,

Hasham

[amitchandak]

@Anonymous , are you able to show dots for each Property Type.

If so either with the measure of column ((hex code need to with #)

Example measure you create one and use that in conditional formatting with the field value option. But that option will not be there with a legend

Brand Color = Switch( true(),
max('Item'[brand]) = "Brand 1" , "red",
max('Item'[brand]) = "Brand 2" , "blue",
max('Item'[brand]) = "Brand 3" , "green",
max('Item'[brand]) = "Brand 4" , "gray",
max('Item'[brand]) = "Brand 5" , "yellow",
max('Item'[brand]) = "Brand 6" , "orange",
max('Item'[brand]) = "Brand 7" , "brown",
max('Item'[brand]) = "Brand 8" , "Cyan",
max('Item'[brand]) = "Brand 9" , "Tan",
max('Item'[brand]) = "Brand 10" , "Violet",
max('Item'[brand]) = "Brand 11" , "Gold",
"silver"
)