Forum Discussion

Riteman's avatar
Riteman
Frequent Visitor
1 year ago
Solved

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?

  • 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.

     

1 Reply

  • 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.