Hi everyone, I've tried almost everything under the sun to hide one of my gauges that is showing up in my straight table (see picture below). I've even tried using a calculated background color based on if the current row, "Key Metrics" so that I could make it gray and it would be hidden essentially. This does not work. Am I missing something?
Here's my expression to calculate one of the segment colors, it seems to just always be false, Measure is the dimension in the table:
=if(Measure='Key Metrics',RGB(240,240,240),RGB(252,115,98))
Don't worry the data is scrambled 🙂