Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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:
Any help would be appreciated, thank you.
Solved! Go to Solution.
Hi - no, putting it in colour saturation provides a gradient of colours. Because this is categorical data I just want three colours.
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!
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.
Check it, let us know
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.
can you please check once, otherwise if possible share some dummy data it helps us to analyse
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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
37 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |