Turn Measures On and Off Inside a Chart with CONTAINS()
Line charts are indespensable, but they can get pretty busy pretty quick. A chart with several related measures can have so many lines on it that they turn into an indistiguishable visual mess. Wouldn't it be great to give users a chart that's got several measure on it, but it allows them to turn individual measures on or off at will? As in, "Show me actuals, and the 6 Month Moving Avg, but leave the 3 Month Moving Avg off."
In this video we're going to show you how to do exactly that nice and easy with a combination of a teeny tiny disconected table and the CONTAINS() function. I think you're gonna find this coming in handy pretty often 🙂