Forum Discussion

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
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()

))