Quick measure Power BI

Question

I'm trying to add an if statement to the quick measure to basically say if the percentage is negative the text should be in red with the negative sign in front, and if its positive the number should be in green with the plus sign in front. but I keep getting an error message.

Answer 1

thank you, but I'am not getting the desire result

Answer 2

Post/ask in the Power BI community:

Welcome to the Fabric Community

Welcome to the Power BI forums

Answer 3

Use the quick measure as the numeric base, then create a separate DAX measure (or visual calculation) that returns formatted text and apply conditional formatting from it.

Assume the quick measure is:

Parts % Diff = 
VAR __BASELINE_VALUE    = SUM('Parts'[2024 ACTUAL])
VAR __VALUE_TO_COMPARE  = SUM('Parts'[2025 ACTUAL])
RETURN
    DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

Create a new measure for the signed, color-driving value:

Parts % Diff Display = 
VAR v = [Parts % Diff]
RETURN
    IF(
        v < 0,
        "-" & FORMAT( ABS(v), "0.00%" ),
        "+" & FORMAT( v, "0.00%" )
    )

Then:

1. Put Parts % Diff in the visual as the value (so it stays numeric).
2. Use Parts % Diff Display only for conditional formatting:
   • For a table/matrix, open Conditional formatting for the Parts % Diff field.
   • Choose Format by: Rules or Field value and select the display (or another helper) measure.
   • Set rules such as < 0 = red, >= 0 = green. When working with percentages, enter rule values as decimals (for example, 0 and 0.25) and choose Number as the format, not Percent.

If using visual calculations (preview), the same logic can be written as a visual calculation and then used as a hex color field for conditional formatting, similar to:

Parts % Diff Color = 
IF( [Parts % Diff] < 0, "#E91C1C", "#5BA300" )

Set its data type to Text, hide it from the visual, and select it in the conditional formatting dialog.

---

References:

• Use quick measures for common calculations
• Tutorial: Create your own measures in Power BI Desktop
• Apply conditional formatting in tables and matrices
• Using visual calculations (preview)