cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Hidden slicer still filters other visible visuals

Hi all,

Could you please tell me how to fix the following issue?
I was trying to make some bookmarks to hide/show visualizations, including the slicers. But if the below easier question does not work, then the bookmark solution is not feasible. Thus, I simplified my orignal issue, so you can easily see the problem, and reporduce the issue on your own PowerBI Desktop. N/B: There are no Filters on this visual/on this page/ on all pages applied.

In Screenshot 1, I have 2 visuals: Slicer and Table, when I select one value in Slicer, the Table is also filtered (as expected).  

darwindat_1-1601548368589.png

But in Screenshot 2, if I hide the Slicer, what I expect, the table would not be filtered, showing not only CORN, but also SBM, RSM,.... However, in reality, the Table shows only CORN, as if the Slicer is still there. As I understand, if the visual is hidden, it doesn't affect any visible visuals. Am I wrong?

darwindat_2-1601548409417.png

 

I was thinking of a workaround to create new page, instead of doing bookmark, but Bookmark would be nicer solution.

Can you guys please help me out? Thank you very much!

1 ACCEPTED SOLUTION

Thanks to @Jef  and @PaulDBrown answers, with some modifications, I finally found a solution to do exactly what I want. 

To help others if they will have the same issue like mine, I will describe briefly again the issue and my solution. 

The first picture is what I want. I have 2 bookmarks, where I hide and show Group of "Visuals in BM 1"/"Visuals in BM 2". 

darwindat_0-1601729902251.png

However, life is not that easy. In reality, while I am viewing Bookmark 1, I click a button to switch to Bookmark 2, then the Country slicer (single select) will be hidden (together with the whole Group "Visuals in BM 1"). Although the Country slicer is hidden, it still affects Group "Visuals in BM 2", resulting in only 1 Country selected country in Bookmark 2. (Please see the second picture). 

2020-10-03_145503.png

 The solution/workaround is not that difficult.  What I did is that first, I have to make sure that in Bookmar panel, BM 1, and BM 2 have the Data, Display, and All Visual checked.

 
 

2020-10-03_165721.png

 

Then in Group "Visuals in BM 1", I delete the Country slicer (single select). As you do with me, if you check now in Bookmark 2, you will see that the Country slicer (Multiple Select) will show all the countries (see picture below).

2020-10-03_171731.png

Now you go back to Bookmark 1, create again the Country slicer (single select), put that slicer back to Group "Visuals in BM 1", then update BM 1 in the Bookmark Panel (see picture below).2020-10-03_172054.png

 

Now you should see the final result like my first picture.

View solution in original post

9 REPLIES 9
Resolver IV
Resolver IV

Yes, it's possible with bookmarks:

 

add a bookmark, and make sure no filters are applied, then click "Update" on the bookmark, make sure 'data' is selected:

Jef_0-1601550162576.png

Now add a button with an action to the bookmark:

Jef_1-1601550196457.png

After clicking the button all the filters will reset. 

 

Hi Jef,

 

Thank you very much for your quick help. In my "original" issue, the slicer should be "Single select". How do you make sure that "no filters are applied" like in your suggestion?

 

Thanks!

I'm quite sure it's not possible to combine a single select with a "select all". 

When using single select you have no other option than selecting 1 item.

To put it simple, I want "Single select" for field A, "Select all" for field B in one bookmark, and "Select all"  for field A, "Single Select" for field B in another bookmark. As I understand from your reply, it seems not possible, right? I think I have no choice to make them separate pages. 
Thanks anyway for your help!

@darwindat 

 

You can have what you need by duplicating the slicers and changing the format. (For the sinlge select, don't use the "Single Select" format option becasue that involves having a value selected, so you can't clear the slicer). Use this option:

format.JPG

 

 

You just need to make sure that when you save the bookmark the values in the slicers you are going to hide are clear (following @Jef  suggestion), and that when you save the bookmarks you have "Selected visuals" option active.

BKm 1.JPGBKM 2.JPG

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Hi @PaulDBrown

Thanks a lot for your detailed reply. Really appreciate that! 
In my "original" issue, I really need to use "Single select", since it doesn't make sense for end-users to choose 2 values or more with that slicer. So I am afraid, that I cannot do as you suggested...

 

Do you have any other smart idea to make it really work in my specific question?

Thanks!

@darwindat 

 

The slicer format I included is in fact a "single select": in other words, the slicer by default allows you to choose a single value at a time (though a user can choose more than one value by the ctrl + click method.) What makes it different from the Single Select format option is that the latter requires an active option (a single value is always selected) whereas the format I included, while it works as single select. it allows you to have no values selected (which you need to switch between bookmarks)

Try the option I suggested. it works. (the only caveat being that in the single select slicer, a user can "force" more than one selection if they use the ctrl + click method). So, if you can live with the possibilitity of a user selecting more than one option by ctrl + click, the method works. (You can always set up a warning message to warn users to only select one value just in case)





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Hi @PaulDBrown,

 

I fully understand your intention now. Maybe it's the only workaround. Thanks!

Thanks to @Jef  and @PaulDBrown answers, with some modifications, I finally found a solution to do exactly what I want. 

To help others if they will have the same issue like mine, I will describe briefly again the issue and my solution. 

The first picture is what I want. I have 2 bookmarks, where I hide and show Group of "Visuals in BM 1"/"Visuals in BM 2". 

darwindat_0-1601729902251.png

However, life is not that easy. In reality, while I am viewing Bookmark 1, I click a button to switch to Bookmark 2, then the Country slicer (single select) will be hidden (together with the whole Group "Visuals in BM 1"). Although the Country slicer is hidden, it still affects Group "Visuals in BM 2", resulting in only 1 Country selected country in Bookmark 2. (Please see the second picture). 

2020-10-03_145503.png

 The solution/workaround is not that difficult.  What I did is that first, I have to make sure that in Bookmar panel, BM 1, and BM 2 have the Data, Display, and All Visual checked.

 
 

2020-10-03_165721.png

 

Then in Group "Visuals in BM 1", I delete the Country slicer (single select). As you do with me, if you check now in Bookmark 2, you will see that the Country slicer (Multiple Select) will show all the countries (see picture below).

2020-10-03_171731.png

Now you go back to Bookmark 1, create again the Country slicer (single select), put that slicer back to Group "Visuals in BM 1", then update BM 1 in the Bookmark Panel (see picture below).2020-10-03_172054.png

 

Now you should see the final result like my first picture.

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors