cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
migoyafe Frequent Visitor
Frequent Visitor

Hidden Slicers

I used a slicer, and undre the View menu, I selected the Sync Slicers options. I then turned off the visibility of the slicer in all of the pages of my report. 

I now need to find that slicer but can't! I'm trying to find an option that shows all the slicers at once, or something like that, so that I can get rid of that slicer once and for all.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
MarcoLopez Frequent Visitor
Frequent Visitor

Re: Hidden Slicers

in the view window, you can open the selection pane, where you can check all the objects in the apge and the right of the list, you will be able to see if an object is hidden or not, if it is hidden you can click on the eye it will appear at the page.
greetings!

4 REPLIES 4
Highlighted
MarcoLopez Frequent Visitor
Frequent Visitor

Re: Hidden Slicers

in the view window, you can open the selection pane, where you can check all the objects in the apge and the right of the list, you will be able to see if an object is hidden or not, if it is hidden you can click on the eye it will appear at the page.
greetings!

embers00 Frequent Visitor
Frequent Visitor

Re: Hidden Slicers

The problem is.... If the slicer is hidden then it doesnt appear on the page to select in the first place. The view slicers only shows thos slicers selected!

 

How can one find a hidden slicer when you cant see it?

 

Martin

AnneC Frequent Visitor
Frequent Visitor

Re: Hidden Slicers

Hi Martin

 

If you are looking for all active slicers and layers to your data set, or want to unhide a hidden slicer, all slicers are visible if you click on the View tab and tick the Selection Pane.  This opens to the right of your data sheet as a list.  I hope this is of use to you.

mohammedkhan Regular Visitor
Regular Visitor

Re: Hidden Slicers

Hi Ember,

I had the similar issue, I downloaded two Images Forward and Backward (show and hide purpose), 

 

mention below is the step by step guide for this issue also find the video for this solution.

https://www.youtube.com/watch?v=7OjY6bcyMg4

 

  1. Place both the images side by side 
  2. Create Two Bookmarks (Show Slicer and Hide Slicer) 
  3. Select Image 1 (Backward Image)
  4. Goto Format Image => Action "Type = Bookmark", "Bookmark = Hide Slicer"
  5. In the Selection pane hide the Image 1(Backward Image) 
  6. Select image 2 Forward Image
  7. Goto Format Image => Action "Type = Bookmark"; "Bookmark = Show Slicer"
  8. In the Selection pane hide the Image 1 (Forward Image) and hide the Slicer (by clicking on the eye)
  9.  On Both the Bookmarks created (select the image) click on the show slicer elipces ... and select update.

 

TIP* place the image on top of each other.

 

Step by Step on Show and Hide Slicer : https://www.youtube.com/watch?v=7OjY6bcyMg4

 

Regards,

Muhammad