Forum Discussion
Conditional Formatting - Row Subtotal Only
Hello community, I have a mockup PowerBI file I created (link at bottom) with dummy data. The visual I need is a matrix and this matrix is essentially a heat map to show which workers are over/un...
See if this works for you:
Create a measure for the condional formatting along the lines of:
Conditional Formatting = VAR CF = SWITCH ( TRUE (), AND ( [Variance] >= 30, [Variance] < 200 ), 1, AND ( [Variance] >= -200, [Variance] < -30 ), 1 ) RETURN IF ( ISINSCOPE ( 'Forecasted Hours by Worker'[Project] ), BLANK (), CF )and use it in the conditional formatting pane as follows:
See if this works for you:
Create a measure for the condional formatting along the lines of:
Conditional Formatting =
VAR CF =
SWITCH (
TRUE (),
AND ( [Variance] >= 30, [Variance] < 200 ), 1,
AND ( [Variance] >= -200, [Variance] < -30 ), 1
)
RETURN
IF ( ISINSCOPE ( 'Forecasted Hours by Worker'[Project] ), BLANK (), CF )
and use it in the conditional formatting pane as follows:
Thank you so much! That worked for the mockup and my actual PBI Data file. I'm glad to know I was at least close in the DAX I was trying. Thanks again!