Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
JennaExe
Helper I
Helper I

Shape map - fill colours, not working on legend

Hi all, can anyone suggest to me why my shape map isn't working as it should be? I've done others this way and not had any issues, but wonder if I'm missing something obvious? I have a text column called "Category" which currently has three things I want to display in three different colours. I've put a location in the location field, and the Category column in the Legend field. The map is displaying the same colour for all three categories, and only changes when I change the first option "less than 10%", even though the other categories definitely are in use in the data. A couple of screen shots: 

JennaExe_0-1724251029299.pngJennaExe_1-1724251044708.pngJennaExe_2-1724251062724.png

Any help would be appreciated, thank you.

1 ACCEPTED SOLUTION

Hi - no, putting it in colour saturation provides a gradient of colours. Because this is categorical data I just want three colours.

View solution in original post

6 REPLIES 6
HotChilli
Super User
Super User

I don't think (from memory) that this works unless you have some aggregation in the Color Saturation field well.

Thank you, I knew it must be something simple, but I thought I'd tried that already! I put the same category field in both wells and then it works as I expected it to - duh! Thanks for your help!

rajendraongole1
Super User
Super User

Hi @JennaExe - I have made a sample data and plot it into a shape map.
To get the color you have to plot values into color saturation. can you add category in color saturation. 

 

rajendraongole1_0-1724252587472.png

 

 

Check it, let us know 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Hi - no, putting it in colour saturation provides a gradient of colours. Because this is categorical data I just want three colours.

Hi @JennaExe - So, have you multiple the category field with percentages.

rajendraongole1_0-1724253024060.png

 

can you please check once, otherwise  if possible share some dummy data it helps us to analyse

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





No, it's okay, I have the solution now - because it's categorical/text data, not numbers - I just needed to put my category field into both the legend well and the colour saturation well at the same time, and it's working as it should. Thanks for trying to help though!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.