Conditional format a matrix column by a measure

Question

I hve a visualization that I am trying to format conditionally. I have a measure (TotalSalesByDay) that is determined by the Top N Days that a user selects with a What-if selector. What I need to be able to do is shade each product that is underperforming red...as illustrated in this example:

The Threshold % field is a user defined What-if Selection and is multipled by the Average Sales to establish the Threshold.

Any product whose sales fall below that threshold need to be shaded red. I have attempted to add the following measure to the conditional formatting option of the TotalSalesByDay field, but it only returns the false response...shading things white/clear and not red:

UnderperformColor = if('Table1'[TotalSalesByDay]<[Threshold],"#efb5b9","#FFF")

I appreciate any help that can be offered.

Thank you in advance!

pauldbrown · Accepted Answer

francino&nbsp;
Use this measure:
UnderperformColor = if([TotalSalesByDay]&lt;[Threshold],1)
in the conditional formatting pane for the [TotalSalesByDay], select the backround colour formatting, and in the options, select Rules and set the value to 1:

&nbsp;

&nbsp;
&nbsp;

Forum Discussion

Conditional format a matrix column by a measure

2 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Matrix Row Conditional Formatting

Conditional Formatting

Condition formatting