Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Color My World

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

 

 

 

HashamNiaz's avatar
HashamNiaz
Solution Sage
5 years ago

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