Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Conditional Formatting the colours of a bubble map (Wrong colour being displayed)

Good Morning


I wonder if I could have a bit of support regarding the below I’ve been using the bubble map visualisation conditionally formatted to turn a set of colours based on a measurement that we have created which I have shown below.




Unfortunately it appeared that the measurement wasn’t working to show the colours on the map the correct way and as an example I can show you the below. As you can see the“Measurement (The heat map uses a combination of the amount of things happening in a place at once as well as a timeframe to work out the total)is  12 if you add 10 and 2 together r however you can see below this it is adding up to 13

underneath the two in the summary.





I did notice this with other areas as well for example in the below you can see the "Measurement" should be two but overall it's coming up as 13 which is what is being used within the heatmap so while the bubble should be showing as Green it is instead displaying black.







The map is conditionally formatted to the measure as per the below




The little issue being it seems to be the “Summary” number appearing at the bottom which the map seems to be taking rather than the sum of the measures individually (I.e so in the first table it should be showing as “Red” with 10 + 2= 12 and in the second should be showing as “Green” taking the number “2” yet but is coming up as black on the map taking the “13” number. In both of these cases the bubble on the map is showing up as black because the map is formatting to that overall measurement rather than the breakdown of what is shown in the measurement column


Do you possibly know why this may be the case and if there is a quick solution to this problem?


Thank you.


Community Support
Community Support

Hi @DanH2000,

Can you please share a pbix or some dummy data that keep raw data structure? It should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  


Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Good Evening.


I have since tried to research how to attach a file on to the community support group and have found that it appears the solution is to attach the link via one drive and because of security within my organisation this would be a bit of a challenge, is there an alternative way for me to attach the Pbi File?

Thank you


Kind Regards

HI @DanH2000,

It seems like your account does not has permission to attach files, perhaps you can upload it to your network driver and share the link here.

Notice: Please remove/replace all sensitive data or build some dummy data with a similar data structure for share.


Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Good Morning.


Thanks for the response.


Hopefully this link works below for the test file.


So basically I want the measure in the table below


to reflect the two numbers shown added together (so 11) rather than 13. I have a map visualisation which you should be able to see which is conditionally formatted so that if the measure hits the number "13" it will be black (this can be based on timelines as seen on the timeline slicer below this visualisation so the value of the measure changes depending on which slice of time is picked). So when picking the slice of time I have picked in September the colour should be showing as "Red" rather than "black".


Hope this makes sense


Kind Regards 🙂





Good Morning


Sure no problem, can you please tell me how to attach as I can't see an "Insert attachment" option when I reply? Or do I need to e-mail


Thank you


Kind Regards




Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors