Slicer "All" value in the drop down

[chyang0107]

Hello,

Thank you for your time in advance. My goal is to use multiple drop-down slicers to filter the finance dataset. These drop-down slicers are derived from the corresponding columns in the finance data. Two questions need your insights

Q1. How to display 'All' in each slicer? 

Currently, each slicer has a default selected value. I would like to use 'All' to deselct any default value.

Q2. How to break the automatic update after slecting one value at one slicer?

Currently, the selected value in one drop-down slicer will change the valuies in another slicer. I would like to maintain the drop down values in each slicer. 

        Many thanks!

         Hank

[Deku · Accepted solution]

1. in the slicer options you can get it give you a select all option.

2. When you select a visual you'll see two extra headers in the ribbon. In one of them there is a edit interact button. Once selected, you can click on visuals and will see icons appear on the headers of the other visual. You can swap between no interaction, or filter, or depending on the visual crosshighlight

[Ritaf1983 · Accepted solution]

Hi @chyang0107 

Select All option is here:

According avoidinf filtering each other, you can edit the interactions between the slicers from here :

More detailed guide fo edit interactions functionality is by the link :
https://www.youtube.com/watch?v=yvcV3KJeCRE

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Deku · Accepted solution]

1. in the slicer options you can get it give you a select all option.

2. When you select a visual you'll see two extra headers in the ribbon. In one of them there is a edit interact button. Once selected, you can click on visuals and will see icons appear on the headers of the other visual. You can swap between no interaction, or filter, or depending on the visual crosshighlight