Searching the forum I found the undocumented function _Color.
Has anyone used this before? I’m unable to get any color change with it.
For example, if a value is less then 4 I would like the text to be red.
I have tried both of these but the text color does not change.
SwitchIf(Average([Work-Life].[Work-Life]) < 4, _Color("red", Average([Work-Life].[Work-Life])))
SwitchIf(Average([Work-Life].[Work-Life]) < 4, _Color("#ff0000", Average([Work-Life].[Work-Life])))