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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

Shape map color saturation doesn't work properly

Hi!

 

I'm trying to create a shape map but when I add my values in "Color saturation" they change either to Count, Sum or whatever instead of show them as they are. I have marked "No calculation" as you can see in the pic but still "Sum" the values.

 

 

1.JPG

 

I've watched several videos on youtube and all of them just drag the values (like population for each region) and it works fine for them...

 

If I add the Counties in the legend then it says "Sum" but the values are actually correct (see pic below). But another issue I have is that the saturation is not working. It changes the colors completely instead of darker the bigger number. I don't have any option for this, just to change the color manually.

 

2.JPG

 

These are the dummy values I'm trying:

 

CountySales
North Scotland10
Central Scotland50
South Scotland75

 

Any help is much appreciated!

 

Thank you! 🙂

1 ACCEPTED SOLUTION
onurbmiguel_
Super User
Super User

Hi again, 

Witch map are you using?

onurbmiguel__0-1660733113404.png

 

 

do you have smaller granularity in the model for the location? seems that your are using a bigger granularity and the map does not recognize the location , thats why you have the same value everywhere.

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


View solution in original post

4 REPLIES 4
onurbmiguel_
Super User
Super User

Hi again, 

Witch map are you using?

onurbmiguel__0-1660733113404.png

 

 

do you have smaller granularity in the model for the location? seems that your are using a bigger granularity and the map does not recognize the location , thats why you have the same value everywhere.

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


Anonymous
Not applicable

Hi @onurbmiguel_ 

 

Thank you! I'm using a custom map, but I think the issue it's what you said. I had only values for the 3 areas of Scotland (as a test) but my map also includes England.

 

I tried adding all zeros as values for the rest of the regions and now it colourises accordingly with no "sum" or "count" !  (see pic below)

 

Thank you very much for taking your time to help me! 🙂 🙂

 

4.JPG

onurbmiguel_
Super User
Super User

hello alicia_mtz

If i´m not wrong, when you add some field in the legend the saturation will not work, try to remove the legend please.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


Anonymous
Not applicable

Hi @onurbmiguel_ 

 

Thanks for your reply! Sorry I forgot to say in my original post that I already tried that.

 

The saturation doesn't work as it becomes "Count sales" and value 3 for all regions, so the colour is the same (see pic below). I don't know why is doing that if I have marked "No calculation" !!

 

3.JPG

 

Do  you know why is this happening?

 

Thank you! 🙂 🙂

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.