Forum Discussion

H0wardM00n's avatar
H0wardM00n
New Member
10 years ago
Solved

Colour data points on a map according to category

Hello Everybody,   I am very new to Power BI and am trying to colour data points in a map according to category and for the life of me can't figure out how to do it. Apologies if this is a very new...
Need Help
H0wardM00n's avatar
H0wardM00n
New Member
10 years ago

I just created a 3 entry table with postcode, category and sale value.  I can get the Size and saturation to change using the value as you point out but i can't get the colour to change... this is a fundamental requirement for us as we want to distinguish quickly and easily visually between different categories and simply adjusting the saturation isn't enough.

 

Oh well... back to the drawing board... or Tableau...

 

Thanks for your help guys.

 

Rob

 

 

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

H0wardM00n Can you post some sample data? Did you try putting Category in the Legend?

  • H0wardM00n's avatar
    H0wardM00n
    New Member
    10 years ago

    Hi Sean, 

     

    I have rebuilt my test model and can now see the individual sites as i expected using the legend.  Thank you for the pointer.  

     

    Rob

    • diegopagura's avatar
      diegopagura
      Regular Visitor
      7 years ago

      Hi everyone! Bumping up this old topic as I have a similar issue with using a map to categorize items.

       

      I know that I can use the location for the country and then the Legend for the category of the items in my dataset.

      However, my issue is that I have sub-categories on my table and I wanted to know if somebody has any idea on how to best show this on a visual in PBI.

       

      For example, I have:

       

      Country      Division    Process Type

      Argentina    Finance      Manual

      Spain           finance       Automatic

      Honduras    Sales          Manual

       

      I guess I can go with using the sub category as the Legend and the main one as a Slicer. Or maybe join the Division and Process type into a single Column and use that as the Legend. 

       

      Any help is much appreciated. 

      Regards,

      Diego