Forum Discussion
Matrix Background color
when amount is divided by area , i want to color each area different color for amount ( can achieve this in conditinal formatting). catch is color the whole column (background) even when there is no...
AmountPerAreaColor1 =
VAR AreaInColumn1 = SELECTEDVALUE('AreaSortTable'[Area])
RETURN
SWITCH(
TRUE(),
AreaInColumn1 = "A", "#FFA07A",
AreaInColumn1 = "B", "#6495ED",
AreaInColumn1 = "C", "#32CD32",
"#FFFFFF"
)
This works but you need to add this measure in matrix as values and find a way to hide it .
This works but you need to add this measure in matrix as values and find a way to hide it .