Forum Discussion
JustinDoh1
4 years agoPost Prodigy
Conditional formatting in Matrix's value
Hi community, I am sharing my Pbix file here. I am trying to apply different Background colors on Matrix. Here is my demo: Currently, this Matrix has two parts. Left side is Actua...
- 4 years ago
You can write a measure to check on the BudgetType[ActualOrEstimated] and return a color string like this.
Value Format = VAR _Type = SELECTEDVALUE ( BudgetType[ActualOrEstimated] ) RETURN SWITCH ( TRUE (), _Type = "Actual", "Green", _Type = "Estimate", "Red" )Then apply conditional formatting to the Values background based on the Field value of the measure:
You can use color hex values instead also.
Value Format = VAR _Type = SELECTEDVALUE ( BudgetType[ActualOrEstimated] ) RETURN SWITCH ( TRUE (), _Type = "Actual", "#34A853", _Type = "Estimate", "#EA4335" )
JustinDoh1
4 years agoPost Prodigy
jdbuchanan71 Excellent! Thank you!