Forum Discussion
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 newbie question.
I have a list of postcodes that i can map but they are all the same size and colour. I want to colour them according to the category that the data point represents, i.e. Hospital, Pharmacy, Shop etc. etc. and then size the points according to the value i assign them (this has been straight forward enough in software such as Regiograph or Tableau but i can't figure it out in PBI). Can someone show/tell me how to do this please or point me in the direction of a resource that will?
I hope this is clear?
Thanks in advance.
Rob
Hi Rob
In Tableau we can show the color difference bec we have separate color Mark,
In power BI also availble its called "Color Saturation"
but it quite different here we cant use the dimension , here we can only use the measure value , its one drawback in power BI, I hope from upcoming update they change ...
am sure now there is no option...
8 Replies
- Baskar
Resident Rockstar
Hi Rob
In Tableau we can show the color difference bec we have separate color Mark,
In power BI also availble its called "Color Saturation"
but it quite different here we cant use the dimension , here we can only use the measure value , its one drawback in power BI, I hope from upcoming update they change ...
am sure now there is no option...
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
SeanCommunity Champion
H0wardM00n Can you post some sample data? Did you try putting Category in the Legend?
H0wardM00n Under Fields where you are putting your location, etc. There is a "Color Saturation" - drop your data point with those categories in there and that should give you different colors for your data labels.
Thank you for the reply Eno1978 but that has had no effect whatsoever.
I have postcodes mapped and each postcode can only sit in 1 category. However when i drop this into the colour saturation it shows 'count of ' and i don't understand why.
H0wardM00n What is the behavior if you click the down arrow next to the "X" on the field row, can you select (Do not summarize)?
I just noticed, you can try the field in "Legend" as well. That should work.
