Forum Discussion
Trescher
9 months agoFrequent Visitor
Conditional formatting of measures
Hi, I have multiple measures in my report and I want to make the font color change based on the value of the measure. Let's say i have two measure; measure A and measure B, which are both pe...
rohit1991
Super User
9 months agoHii Trescher
In Power BI, conditional formatting always evaluates a specific field, so you cannot dynamically reference “the current measure” without pointing to it. To avoid writing separate logic for each measure, the recommended solution is to use a Calculation Group (via Tabular Editor) or Field Parameters, where a single calculation can apply the same color logic (≥0 green, <0 red) across all measures dynamically. Without calculation groups, each measure must be referenced individually.
Trescher
9 months agoFrequent Visitor
Thx Rohit, is there a step by step guide somewhere to achieve this? I tried with chatgpt but it seemed rather complex.