button for slicer selection

[chrmeehan]

I'm looking to create or use a button to select specific slicers that are avaialble on a report. For example...

ProductA

ProductB

ProductC

When I select the button only, A & C are selected from the list. Anyone have an idea on how to bring this into a report?

Thanks

Chris

[Anonymous]

@chrmeehan You could create a column or seperate table with the value that would sort the way you want.

then create 2 slicers. The first being either a single value (button) to select only those products that are "1" (you do this by creating a table visual, filtering to only the value you want, then changing it to a slicer)

Then, when you select that "button" the slicer for product will change filter to only those you want.