Any way to show only the selected item in an excel Slicer?

[Ravi Dawar]

Hi,

I have built an excel dashboard which shows sales in the past 10 years across our customers. The customer names are in a slicer. Sometimes, the same customer might exist multiple times because of the raw data. e.g. ABC corp. might appear as abc Corp. or ABC corporation or ABC Corp. Therefore, I have placed a dropdown next to the slicer (see top right corner in the screenshot below) to find the customer easily. So, the user can select all of them together using the search dropdown.

The customer list is very long so once a selection has been made, there is no way to look what customers were selected in the slicer as the slicer still shows the complete list. e.g. here is a snapshot with a customer selected -



Is there a way to only show the customers selected in this slicer and hide the rest of the values?

Thank you for the help.

 

[Chihiro]

I'd set it up little differently.

I'd set up multiple slicers. Each level narrowing down selection available.
All slicers are set to show only available values.


See attached sample.

 

[Chihiro]

Another method is to create copy of pivot table with only customer as row field to serve as indicator of what's been selected.

See attached.

FYI - If you have PowerPivot, there's another method. See links.
https://eriksvensen.wordpress.com/2...y-selected-slicer-items-in-separate-slicer-2/
https://eriksvensen.wordpress.com/2012/08/23/how-to-get-selected-items-in-a-slicer-without-vba/