Make the line in Line and Clustered Column Chart Optional.

[bschil98]

Is there a way to make the line in a line and clustered column chart optional? Right now, I have a calculated measure as the line in the visualization. My current thought process is to somehow make a slicer that asks yes/no or just check/uncheck for the calculated measure to be a line.

[AlexisOlson · Accepted solution]

You could define a new table Slicer with a single column of two values "Yes" and "No" and then use the selected value to determine whether or not to return a blank for the line measure.

OptionalMeasure = IF ( SELECTEDVALUE ( Slicer[ShowLine] ) = "Yes, [LineMeasure] )