Slicer on combo chart

[zilaifeng]

Hi,

Say if I have a combo chart with line and bars, is there a way to put a slicer so that I can choose to view line only, bars only, or both?

Thanks!

[SteveCampbell]

The other way, is to make a slicer table:

Home > Enter Data > add "Line" and "Bars", call it "FilterTable" and click load.

Now, add two measures:

Bars = if( "Bars" in VALUES(FilterTable[Value]),
    <<Your Column Measure>>
    BLANK()
)

Line= if( "Line" in VALUES(FilterTable[Value]),
    <<Your Line Measure>>
    BLANK()
)

Add "Lines" measure to the line value and "Bars" masure to the column value.

You can add the FilterTable[Value] column as a slicer, and toggle on and off the bars and line.

[SteveCampbell · Accepted solution]

You can, but it takes a little work. The easiest way would be with butons and bookmarks. 

I reccomend you read the links in this reply.

Duplicate the graph three times, one with just lines, one with bars, one with both.

Hide two graphs. Open the selection pane and highlight the three graphs.

then record a bookmark with just one graph visable. Rename the bookmark the same as the visable graph. 

Repeat for all three.

Under bookmark settings, open the slipsis and select only "Disaply" and "Selected Visuals":

Nowe, make three buttons by home tab > insert > button > blank. Under the Action field in their properties select bookmar, and select the column bookmark. Under button text, you can write column only. Repeat for line and both.

Now, selecting the buttons will show the desired output (hold CONTROL and click if you are in the desktop).