Forum Discussion
Add conditional formatting to series chart
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 serie...
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:
Go to Data colors → Conditional formatting → Field value
Select the measure SeriesColor
This gives dynamic coloring per data point and effectively replicates per-series conditional formatting.