topic Turn Measures On and Off Inside a Chart with CONTAINS() in Webinars and Video Gallery https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Turn-Measures-On-and-Off-Inside-a-Chart-with-CONTAINS/m-p/151045#M16 <P>Line&nbsp;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&nbsp;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."&nbsp;</P><P>&nbsp;</P><P>In this video we're going to show you how to do &nbsp;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 <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P><SPAN class="videoUrl hidden">watch?v=nF9yAeojtxQ</SPAN></P> Wed, 29 Mar 2017 22:51:24 GMT BrianGrant 2017-03-29T22:51:24Z Turn Measures On and Off Inside a Chart with CONTAINS() https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Turn-Measures-On-and-Off-Inside-a-Chart-with-CONTAINS/m-p/151045#M16 <P>Line&nbsp;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&nbsp;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."&nbsp;</P><P>&nbsp;</P><P>In this video we're going to show you how to do &nbsp;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 <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P><SPAN class="videoUrl hidden">watch?v=nF9yAeojtxQ</SPAN></P> Wed, 29 Mar 2017 22:51:24 GMT https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/Turn-Measures-On-and-Off-Inside-a-Chart-with-CONTAINS/m-p/151045#M16 BrianGrant 2017-03-29T22:51:24Z