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 TypeColor codeColor I am ExoectubgColor on Map
LeasedFF0000RedGreen
Owned0000FFBluePurple
Commercial Morgtage00FF00GreenBlue
Auto00FFFFCyanRed

 

Please help me fix this problem.

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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"
)
  • 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