Conditional formatting of measures

Hi Trescher,

Thank you for your thorough follow-ups and for testing the recommended solutions.

After reviewing the available options, this scenario is not currently supported in Power BI. Conditional formatting for font color in table or matrix visuals always needs a specific field reference. Power BI does not dynamically evaluate SELECTEDMEASURE() per cell for font color formatting, so the formatting measure returns blank values, even if icon formatting works.

Due to this limitation, you cannot apply one dynamic font-color rule across multiple independent measures without referencing each one individually. The only available workaround is to create separate color measures for each value measure, even if the logic is similar.

This is a product limitation by design, not a DAX issue. If this feature is important for your needs, please consider submitting a feature request on the Power BI Ideas portal.

Thank you for your understanding, and thanks to the community for their contributions.

If still faces the same issue then please consider raising a support ticket for further assistance.

To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

Thank you.

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

Because all your measures are shown in the same table/matrix, you can use dynamic conditional formatting with SELECTEDMEASURE(). This lets one single rule apply to any measure placed in the visual.

Create one formatting measure like this:

Font Color =
VAR v = SELECTEDMEASURE()
RETURN
IF( v < 0, "#C00000", "#00B050" )

Then, in your table or matrix:

1. Open Conditional formatting → Font color

2. Choose Format by: Field value

3. Select Font Color (the measure above)

Hi Trescher 

Unfortunately, Power BI doesn't have built-in dynamic formatting that automatically applies to multiple measures at once. Each measure needs individual conditional formatting rules. However, we can create a maintainable system using a single formatting measure that all the measures reference.

Create a single formatting measure that determines color based on any input value:

Universal Color Format =
VAR CurrentValue = SELECTEDMEASURE() // Gets the value of whichever measure is being formatted
RETURN
IF(
ISBLANK(CurrentValue),
"#FFFFFF", // White for blank
IF(
CurrentValue >= 0,
"#00B050", // Green for >= 0
"#FF0000" // Red for < 0
)
)

Apply this to each measure individually
Select your table/matrix visual
Go to Format pane → Field formatting
Find Measure A → Conditional formatting → Font color
Choose "Field value" and select the [Universal Color Format] measure
Repeat for Measure B, Measure C, etc.

Instead of measures A and B use two measures "Value" and "Color" .  "Value"  will calculated the respective value (A or B) depending on where you are in the visual, and "Color" is an identical copy that provides a color name instead of the values, and can then be used for the conditional formatting.

This is a very common approach for all these vain "Make it look like Excel"  custom matrices.

Hey Trescher ,

I did go down a rabbit hole for this. Well after some hours wasted because I thought oh well what a simple requirement. Anyway, calculation groups cannot do the magic nor can the measure approach with SELECTEDMEASURE (at least not in the ways I tried them). The cleanest solution I could come up with, still requires two measures), was to create an UDF (you will have to enable it in preview features) which goes something like this:
DEFINE FUNCTION GetColor = ( value: NUMERIC ) => IF(value > 0, "#00B050", "#FF0000")
EVALUATE { GetColor(100) }

Run this and upload from the DAX query view.

Then writing the Color measure for your actual measure becomes a breeze. You will be simply writing the coloring measure as follows:
Sales Color = GetColor([Sales])
Profit Color = GetColor([Profit])

Hope it helps!

Hi Trescher,

Thank you alish_b lbendlin krishnakanth240 cengizhanarslan for your responses to the query.

Has your issue been resolved?
If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone. 

Thank you for your understanding!

Hi Trescher,

Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you for your understanding and assistance.