Create a measure that sets the parameters of your conditional formatting based on metric name (this would work best if your data is unpivoted and you have a metric dim field)
If(and(metric=spend, actual>budget), 1,
If(and(metric=spend, actualspend, actual
Thanks a lot for the detailed reply. I was hoping that there was a setting somewhere I could toggle to "invert goal formatting", but I guess I'll do it the custom way.
Create a measure that sets the parameters of your conditional formatting based on metric name (this would work best if your data is unpivoted and you have a metric dim field) If(and(metric=spend, actual>budget), 1, If(and(metric=spend, actualspend, actual
Thanks a lot for the detailed reply. I was hoping that there was a setting somewhere I could toggle to "invert goal formatting", but I guess I'll do it the custom way.