Apply conditional formatting to multiple columns in a Matrix or Table

[BrianJ]

@JarrettM,

I agree. This came up last week in a different context, and I thought it might be doable with Calculation Groups in Tabular Editor, but I did some research on that and it appears not to be possible (yet…)

• Brian

Conditional format negative percentages

@suzanne, This is a cool concept, and I would love to be proven wrong here but I don’t think it’s possible to fully automate this in the way you are requesting. I think to implement this type of logic based on measure name, you would need to use calculation groups. While you can dynamically format strings using this technique https://www.sqlbi.com/articles/dynamic-format-strings-with-calculation-groups/ at this point you can’t apply font or background colors in the same way via tabular models…