single colored bubble on the basis of average value on map instead of a pie

[ashish_soni]

Hi,

i want single colored bubble on the basis of average value over the location on map instead of a pie having different colors corresponding to each value.

Thanks

[v-huizhn-msft]

Hi @ashish_soni,

Is there any chance to share your sample data, and list the expected result based in the table? What's the mean of average value over the location? You want to create average of Latitude and Longitude? 

If you want to create Power BI Mapping With Latitude and Longitude Only, please refer to this article.

Best Regards,
Angelia

[ashish_soni]

Hi @v-huizhn-msft,

In Sample2.png you can see that the table contains 6 rows, for each site ID there are two SHS color codes, I want a single color code on the basis of Average of site health Score, and then on this basis SHS color code should be determined to be either 0 or 1 or 2...... so that I could get a single colored bubble in the map. Also DAX used for creating color code column is-  SHS Color Code = if([Site Health Score]=100, 0, if([Site Health Score]>80, 1, if([Site Health Score]>60, 2, if([Site Health Score]>40, 3, 4)))). I also tried with measure but I am unable to put measure as a legend. 

In sample1.png the obtained result is shown which is not acceptable.

Sample3.png has all the data, SHS is calculated as average(AHS).

sample1.pngsample3.pngsampl2.png

Regards,

Ashish Soni

[v-huizhn-msft]

Hi @ashish_soni,

Thanks for your detail description, I am still confusing your expedted result. 

Yes, measure is unable to use Legend level. You can create a calculated column and select it as Legend level.

Best Regards,
Angelia