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
HashamNiaz's avatar
HashamNiaz
Solution Sage
5 years ago

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'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