How to add conditional formatting to Dax measures

[PBI-Curious]

PBI Community Good Day!

Need to add conditional formatting to the dax measure below.

The results will be a net positive number or net negative number, if negative I want the formatting to be red.

How can modify dax to include formatting?

Net Timing 2 = CALCULATE(

 -1 * SUM( metricssalescustomer[amount] ),

metricssalescustomer[sales_type_lvl1]

    IN { "Lost - Timing", "Decline - Timing", "Upsell - Timing", "New - Timing" }

[AUaero · Accepted solution]

Conditional formatting is a feature of the visual, not the measure.  If your measure is displayed in a table or matrix, take a look at this link for additional information.

Apply conditional table formatting in Power BI - Power BI | Microsoft Docs

[Seanan · Accepted solution]

Hi @PBI-Curious 

I've created a basic example below:

Sum = SUM('Values'[Value]) + 0

This first code would essentially be your Net Timing 2 function.

Create a second function using the following code:

Colour = 
    VAR _SUM = SUM('Values'[Value])
    VAR _Colour = IF(_SUM < 0, "#DB271C", "#73B761")
    return _Colour

Replacing the _SUM code with your first function code again.
Now in your visual click on the drop down where your first measure is located and select conditonal formatting.

Select background colour -> Change the format style to field value -> Select your colour measure and hit ok.

Any tile with a negative number will now appear red and any non negative numbers will be green.

[AUaero · Accepted solution]

Conditional formatting is a feature of the visual, not the measure.  If your measure is displayed in a table or matrix, take a look at this link for additional information.

Apply conditional table formatting in Power BI - Power BI | Microsoft Docs