Power BI Map formatting

[Shiraj0205]

I want to generate a Power BI report (Map), where I want to plot service centers (City names) throughout United states.

Data Fields are:

City
State
Service Type (2 Types- say Type1 and Type2)


I was able to plot the cities on map but didn't find options to do below:

1. Conditional color formatting. Based on Service Type mark the cities in different color.

I can achieve this manually, but need it automatically based on service type as I have 5000 + data points.

I know we can do it using color saturation, I simply need data points in 2 colors based on field type.
 
 
2. Show the empty map in background. Remove map texture.
  
3. Show data points of certain type on top (forward). E.g. I have City with both service types. I want to show type1 in Red and Type2 in Green. Here I want type1 (Red data points) overlapping type2.

4. Make all data points (circles) smaller.

Please let me know if this is doable with Power BI.

[v-qiuyu-msft · Accepted solution]

Hi @Shiraj0205,

1. Conditional color formatting. Based on Service Type mark the cities in different color.

I can achieve this manually, but need it automatically based on service type as I have 5000 + data points.

I know we can do it using color saturation, I simply need data points in 2 colors based on field type.
 
In your scenario, you can put [Service Type] field as Legend value, then turn on the legend value, you will see each service type value display in different colors, you can also change their colors. See:

2. Show the empty map in background. Remove map texture.
 
In Power BI, the Map visual is based on the Bing map to display data in corresponding location. Currently, we are not able to remove map texture in the map visual.

3. Show data points of certain type on top (forward). E.g. I have City with both service types. I want to show type1 in Red and Type2 in Green. Here I want type1 (Red data points) overlapping type2.

The legend values in a map visual will display as slicers and consist of one pie. We are not able to make then overlapping currently.

4. Make all data points (circles) smaller.

As there is no OOTB feature for us to specify data points size, when we don't place any field in Size property, all circles will looks the same same and small.

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

Best Regards,
Qiuyun Yu