Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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.
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.
These are the dummy values I'm trying:
County | Sales |
North Scotland | 10 |
Central Scotland | 50 |
South Scotland | 75 |
Any help is much appreciated!
Thank you! 🙂
Solved! Go to Solution.
Hi again,
Witch map are you using?
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 again,
Witch map are you using?
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
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! 🙂 🙂
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
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" !!
Do you know why is this happening?
Thank you! 🙂 🙂
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
85 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
97 | |
71 | |
67 |