Forum Discussion

Imrans123's avatar
Imrans123
Advocate V
4 years ago
Solved

DAX Conditional Formatting, return blank icon

Was wondering if anyone could help.    I have a table with rows of metrics, and for each metric I have a Current year measure and a previous year measure.    I have a matrix where the rows are me...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Imrans123 , try blank

     

    IF(

    HASONEVALUE('Metric'[Metric Name])

    SWITCH (

    VALUES ('Metric'[Metric Name]),

    "Sales", IF([Sales]>[Sales PY], "TriangleHigh","TriangleLow"),

    "Expenses",IF([Expenses]<[Expenses PY], "TriangleHigh","TriangleLow"),

    "Profit",IF([Profit]>[Profit PY], "TriangleHigh","TriangleLow"),

    blank()

    ))

amitchandak's avatar
amitchandak
Super User
4 years ago

Imrans123 , try blank

 

IF(

HASONEVALUE('Metric'[Metric Name])

SWITCH (

VALUES ('Metric'[Metric Name]),

"Sales", IF([Sales]>[Sales PY], "TriangleHigh","TriangleLow"),

"Expenses",IF([Expenses]<[Expenses PY], "TriangleHigh","TriangleLow"),

"Profit",IF([Profit]>[Profit PY], "TriangleHigh","TriangleLow"),

blank()

))

Imrans123's avatar
Imrans123
Advocate V
4 years ago

Perfect! Thanks!