Forum Discussion

gooranga1's avatar
gooranga1
Power Participant
10 years ago

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...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

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.

 

2. Design a Map without Color saturation specified.

 

3. Design a Map with Color saturation specified.

 

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

 

Best regards,
Qiuyun Yu

gooranga1's avatar
gooranga1
Power Participant
10 years ago

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