Add conditional formatting to series chart

[RaquelAlba]

Hi!

I am trying to add conditional formatting to a custom series chart.
I know that in the documentation it says the following:

"We recommend that you don’t use conditional formatting with series. Instead, you should allow customers to format each series individually, making it easy to visually distinguish between series. Most out-of-the-box visuals with series, share this approach."

The fact that it says that it is not recommended means that it is possible but still I don't know how to make it work. 
The color picker works fine, so when one of the grouped values (series) is full color formatted it works but when I try to use the conditional rules the same way it doesn't work. It doesn't even get saved inside the grouped values. 

So I'm not sure about how to approach this. I tried to link it to the categorical column instead of the series but in that case it doesn't work either (not even the single colour picker), so that's worse I think. I still try to make it work linking it to the grouped values but don't know how to do so and make the conditional rules work.

Can you please help me with that?
Thank you in advance for the helping hand! 

[Olufemi7]

Hi @RaquelAlba, 

Conditional formatting on series in Power BI and Fabric charts does not work reliably because series colors are metadata, not row-level data. Static colors per series always work, but conditional rules applied to series do not persist.

Official Microsoft documentation: Conditional formatting in Power BI visuals explains that conditional formatting is evaluated per data point or category, not per series.

Recommended Workaround: Measure-Driven Coloring

Create a measure that outputs a color per data point:

SeriesColor =
SWITCH(
    TRUE(),
    [Value] >= 100, "#00B050",   // green
    [Value] >= 50,  "#FFC000",   // amber
    "#C00000"                     // red
)

Then in your chart:

1. Go to Data colors → Conditional formatting → Field value

2. Select the measure SeriesColor

This gives dynamic coloring per data point and effectively replicates per-series conditional formatting.

[Mauro89]

Hi @RaquelAlba,

Iam not sure about your assumption that if the docs say "it is not recommended" that this feature is acutally present.

Anyway, what is the reason you choose a custom visual instead of one of the core visuals? Which functionality is missing or which feature do you want to implement?

Best regards!