How to hide all visuals until I clicked on "Apply Slicer Button"

[User232431]

Hi , how to achive the functionality with the buttons that,
1. Apply All Slicers - Then Show all the visuals.
2. Clear All Slicers - Then Hide all the visuals.

3. If i dont apply any slicers (default) -  Then Hide all the visuals.

The Actuals Screen shot shows the default's

Thanks in advance.

[shafiz_p · Accepted solution]

User can apply other slicer selection using the bookmark option too by unchecking data option. I think user want to apply other slicer selection by clicking Apply All Slicer button as well as show related visuals. And want to clear other slicer selection and hide visuals by clicking Clear All Selection. So, data option in bookmark can maintain original action of such buttons too.

For example, I want to filter my visuals by S in the slicer.  See image:

After selecting S in slicer, then click Apply all slicer will filter data as well as show hidden visuals. See image:

And you know Clear all slicer will take you to the default, hide and clear all slicer and visuals. So the data option need to use in this case to get desired results:

@User232431  Please check this answer too.

Hope this helps!!

[danextian · Accepted solution]

Hi @User232431 

The simplest thing I can think of is to use a white shape overlaying all visuals except for the slicers and the buttons.  The buttons are linked to bookmarks and are not the clear/apply slicers butotn.  The white shape becomes visible when clicking the apply slicer bookmark button and invisible when clicking the clear all slicers button.

[Anonymous]

Hi @User232431 ,

Did  shafiz_p、Bibiano_Geraldo、tharunkumarRTK reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.

Best regards,

Adamk Kong

[Bibiano_Geraldo · Accepted solution]

Hi @User232431,

Unfortunately, Power BI doesn’t allow you to directly control slicers in the way you're describing. You would typically use bookmarks, but bookmarks don't allow for conditional logic based on slicer selections.

However, you can achieve a similar effect by leaving values blank when any slicer is filtered. The downside of this approach is that if the user doesn’t select any filter, intending to view all data at once, they won’t see anything due to the condition that checks for filters.

Here’s an example of how to adjust a basic sales measure to respond to slicers:

Original Measure:

Sales Amount = SUM(YourTable[Sales_Column])

Modified Measure:

Sales Amount = 
IF (
    ISFILTERED([Column1]) || ISFILTERED([Column2]) || ISFILTERED([Column3]),
    SUM(YourTable[Sales_Column]),
    BLANK()
)

With this measure, Sales Amount will display the sum only when one or more slicers are active. When no slicer is selected, it will return a blank, preventing data display.

[danextian · Accepted solution]

Hi @User232431 

The simplest thing I can think of is to use a white shape overlaying all visuals except for the slicers and the buttons.  The buttons are linked to bookmarks and are not the clear/apply slicers butotn.  The white shape becomes visible when clicking the apply slicer bookmark button and invisible when clicking the clear all slicers button.

[tharunkumarRTK]

@muhammad_786_1 , @shafiz_p 

I really like the approaches you suggested. But I think there are a couple of problems, as per my understanding you are suggesting to change the action type of "Apply all slicers" and "Clear all slicers" buttons to bookmark navigation.

It defeasts the pupose of buttons.

Number 1:

I mean, Unlike other buttons,  the purpose of "Apply all slicers" and "clear all slicers" are different.  if you have multiple slicers on your report page "Apply all slicers" button would be grayed out and will not do anything until you make atleast one selection 

with out any selection:

with selection:

which means, with out any selection, even if you click on "apply all slicers" it wont do anything. But if you change the action type to bookmark, no matter what the selections are, your button will always unhide the visuals, isn't it?

Number 2:

If you observe the users ask, 

3. If i dont apply any slicers (default) -  Then Hide all the visuals.

With out any selections, the visuals should get hidden on its own, with the bookmarks approach, even if you remove selections on the slicers, it will not hide the visuals. User need to perform one more click to hide the visuals. Isn't it?

[shafiz_p · Accepted solution]

User can apply other slicer selection using the bookmark option too by unchecking data option. I think user want to apply other slicer selection by clicking Apply All Slicer button as well as show related visuals. And want to clear other slicer selection and hide visuals by clicking Clear All Selection. So, data option in bookmark can maintain original action of such buttons too.

For example, I want to filter my visuals by S in the slicer.  See image:

After selecting S in slicer, then click Apply all slicer will filter data as well as show hidden visuals. See image:

And you know Clear all slicer will take you to the default, hide and clear all slicer and visuals. So the data option need to use in this case to get desired results:

@User232431  Please check this answer too.

Hope this helps!!

[muhammad_786_1]

Hi @User232431 

You can use the bookmarks in Power BI to get the desired results.

 

 

I've also attached a link to a reference file. You can check it out as well.

File

Best Regards,
Muhammad Yousaf

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

LinkedIn

[tharunkumarRTK]

@User232431 

I dont think there is any direct option available for this functionality. Also, I dont think you can capture the state of "Apply all slicers" and "clear all slicers" buttons with DAX.

However you can tweak your report and achieve the similar experience, These are my suggestions:

1. Move all your slicers to a different page, make that page as first page of your report. Insert a page navigation button, Users will make all the selections on page 1 and then they will click on the page navigation button to look at your visuals. You can add a back button on your page 2, if user wants to change the selections they will move to first page (page 1). 

2. Keep a shape object over your report visuals, And conditionally format the Fill color. And your logic can be, when there is any selection then transperant color else white. Please aware with this approach, users will not be able to interact with your visuals. 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[shafiz_p]

Hi @User232431  You can acheive this using bookmark. Create two bookmark for hide and show. See examples:

I want to hide/show the visuals:

Open selection and bookmark pane from view tab. See image:

Hide visuals you want to hide from selection pane first and then click add button in bookmark and rename it by double click to Hide.

Again create show bookmark by clear all using show option in selection pane and click add button in bookmark and rename it by double click to show.

Now click show bookmark, click 3 dots. A option pane will popup. Uncheck data and click update. See image:

Bookmarks are ready to use.

Select Apply All slicer button, go to format pane and go to action and change type to bookmark and select bookmark to show. See image:

Same as for Clear All Slicer. Change to bookmark to hide. and you are done. Now you are able to clear visuals by clicking clear all slicer button and show all visuals and filter visuals by slicer selection by Apply all Slicer button.


Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,

Shahariar Hafiz