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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Color/circle setting in MapBox

Hello.

I'm working with the mapbox visualization. The case is such that I have chosen three colors (screenshot attached). This color shows how much a item is filled. Represents the fill rate of an object.

Green color = Lots of space
Yellow color = Half full
Red color = Soon full

map box.png

The problem is that I will only show these three colors, but the scaling will not be correct. As you can see on the screenshot attached, the scaling changes colors when it approaches one of the selected colors. Such as orange in this case. I only want to show the selected three colors? How can this be achived?
Thank you in advance.

1 ACCEPTED SOLUTION
v-jiascu-msft
Employee
Employee

Hi @Anonymous,

 

There could be more than three values. How can the MapBox know which is small, which is big? Since you just need three colors, we can group the values like below. 

Measure 12 =
VAR total =
    SUM ( Table34[Index] )
RETURN
    IF ( total < 30, 1, IF ( total < 90, 2, 3 ) ) // adjust the values to your needs.

Color_circle_setting_in_Map_Box

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-jiascu-msft
Employee
Employee

Hi @Anonymous,

 

There could be more than three values. How can the MapBox know which is small, which is big? Since you just need three colors, we can group the values like below. 

Measure 12 =
VAR total =
    SUM ( Table34[Index] )
RETURN
    IF ( total < 30, 1, IF ( total < 90, 2, 3 ) ) // adjust the values to your needs.

Color_circle_setting_in_Map_Box

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanx alot for ur help! Works perfectly. 

Cheers Mate

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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