cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gooranga1 Impactful Individual
Impactful Individual

Using Diverging Data colours on a map Visualisation

I am just starting out with Power BI.

 

I have a map (not filled map) visualisation and I can plot locations on it via lat/long which works ok.  

 

In the Values field I have the number of events at a location and this determines the size of the bubble. When I add a "Failure Ratio" measure for each location in the Color Saturation field I wanted to be able to colour each bubble depending on how many failed failed events took place at a location.

 

The measure is a % formatted field and whatever I do I cannot get the colour saturation to work for the bubble, It just stays the same colour as it was set to before I added a field to Color Saturation.

 

I have switched Diverging to On and set the min/center/max fields with colours and added the values for them but I can't see this on the location bubbles in the map.

 

Am I missing something with this setting or is it a bug? Can you use a measure defined in powerbi in the Color Saturation field setting?

 

Thanks for any help!

3 REPLIES 3
gooranga1 Impactful Individual
Impactful Individual

Re: Using Diverging Data colours on a map Visualisation

When I concatenate lat and long and use that in the Location field and remove Latitude and Longitude fields from the selection the Color Saturation works fine.

 

Is that a known issue? 

Community Support
Community Support

Re: Using Diverging Data colours on a map Visualisation

Hi gooranga1,

 

According to your description, you have created a "Failure Ratio" measure in Power BI data section. I would like to know how do you create this measure, via “New Measure” option or “New Column” option?

 

Based on my test in my environment, we create a new column named “Failure Ratio” to return failure ratio values, then use this new column to set Color saturation property. Bubble color saturation will be different though Diverging is Off. Please refer to screenshots below:

 

1. Add new column "Failure Ratio" in Data section.

q1.PNG

 

2. Design a Map without Color saturation specified.

q3.PNG

 

3. Design a Map with Color saturation specified.

q2.PNG

 

If you have any question, please feel free to ask.

 

Best regards,
Qiuyun Yu

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

Re: Using Diverging Data colours on a map Visualisation

Hi,

 

The only difference I can see from your screen shots is that you are using the same measure for Values and Color Saturation.

 

In my pbix I am using 1 measure for Values (Total Events) and another measure (Failure Ratio) as the color saturation.

 

I am just in the process of creating a test pbix file with anonomised data to test this behaviour to send to support if necessary.

 

Thanks

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors