Forum Discussion
Conditional formatting using multiple calculation groups
I have a question. I have a matrix where I want to use two calculation groups: one for Time Intelligence and another that controls the selected measure. I also have a generic measure that I use in th...
FormatColor =
VAR CurrentItem = SELECTEDVALUE('Time Intelligence'[Time Intelligence])
RETURN
SWITCH(
CurrentItem,
"Variation1", IF([generic_measure] < 0, "#FFC7CE", "#C6EFCE"),
"Variation2", IF([generic_measure] < 0, "#FFC7CE", "#C6EFCE"),
BLANK()
)
Then on generic_measure, go to conditional formatting > background color > format by Field value > pick FormatColor.