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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
alicia_mtz
Helper II
Helper II

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 


 


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 


 


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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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