Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Riteman
Frequent Visitor

Conditional formatting of bubbles in a Scatter plot

 

I have a Scatter plot with a lot of data which is displayed using Legends . I have set up a Measure to color code the bubbles but I am unable to find a place where to install that Measure to control the colors of the bubbles. 

I googled and finally found a single sentence: "If you use Legends it will not work"

 

1 Is that so?

2 Any fix for that issue?

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Riteman 
When using Legends in a Scatter plot (or similar charts with categorized colors), it’s not possible to apply Conditional Formatting to control the bubble colors. The two features—Legends and Conditional Formatting—are mutually exclusive. You’ll need to choose between coloring by Legends or by a Measure for Conditional Formatting. Unfortunately, they can’t work together in the same visual.
You can suggest the issue as an idea:
https://ideas.fabric.microsoft.com/ideas

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @Riteman 
When using Legends in a Scatter plot (or similar charts with categorized colors), it’s not possible to apply Conditional Formatting to control the bubble colors. The two features—Legends and Conditional Formatting—are mutually exclusive. You’ll need to choose between coloring by Legends or by a Measure for Conditional Formatting. Unfortunately, they can’t work together in the same visual.
You can suggest the issue as an idea:
https://ideas.fabric.microsoft.com/ideas

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.