Forum Discussion
Solved
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...
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" )
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"
)