How to show calculated column data in bubbles of Map?

[sayyedkohler]

Hi,
I want to design a Map in which I need to show calculated column value in center of bubble of PowerBI Map.
also I want to change bubble color as per column data.

eg if data is less than 5 then red, more than 5 then green.
Any idea


Thanks

[amitchandak]

@sayyedkohler , If you are using map, without legend, You have conditional formatting available under data column , you can create a measure like this and use in conditional formatting with field value option

if(sum(Table[Value]) >5, "green", "red")

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[sayyedkohler]

Even after converting map into Clustered column chart, I am not able to get conditional data colors.
Check Screenshot

[v-kelly-msft]

Hi  @sayyedkohler ,

Check the similar thread below:

https://community.powerbi.com/t5/Desktop/Conditional-Formatting-in-Maps/m-p/649561

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!