Forum Discussion

jbhca12's avatar
jbhca12
Icon for Helper I rankHelper I
5 years ago
Solved

Slicer not fully disabled

Hi Everyone, New to the forum and learning Power BI on the fly in a fairly new position. Here's my issue and yes, I have searched, A LOT, for an answer and cannot locate anything. I have a slic...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi jbhca12 ,

     

    I followed the tutorial and I notice that every time he changes from custom to another type of visualization he selectes the full slicer.

     

    This is mentioned on the comments of the youtube video:

     

     

    What I think you need to do (to have the reset) is use bookmark has I refered that way you can force the data to be reset something similar to this:

     

    In this case I have hidden the period selection because I believe is more user friendly in terms of user experience, left the selection of the period so that the user can see what he has available.

    Just giving options the slicers have the following options:

     

     

    Depending on the rest of the interactions with your report you may need to change the other options on your bookmark specially the Data and Selected visual options

     

     

     

jbhca12's avatar
jbhca12
Icon for Helper I rankHelper I
5 years ago

I think this may be the solution. I have one "minor" issue I am working on that I'd like to get some guidance on and then I think I can mark this as solved.

My slicer panel opens and closes by clicking on an image. I have the slicer panel opening based upon a bookmark with data unchecked. This way, whatever the slicer selections were when the slicer panel was closed will be preserved if/when the user re-opens the panel. This leads me to my one and hopefully final question relating to the status of the date period slicer and the date range slicer...

Is there a way to programmatically show or hide a visual? I know you can do this with a bookmark, but, for example, if the user has a custom date range selected and closes the panel, I want that same selection to show when the panel is re-opened. So it's kind of related to the solution provided.

Thanks!

MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi jbhca12 ,

 

In this case you need to have two additional bookmarks and link them to the data bound:

 

If you click on the several images you can see that according to the selection you have different changes of the visualizations.

 

Be aware that you may need also to create another one for the case when you select the predefined values to hide and show, then depending on the bookmark you are you present the corresponding button, so if tyou have just selected custom period you need to show the button custom period hide (no matter if the selection of the period was done or not) however the button after hidding a custom period is the custom period show data.

  • jbhca12's avatar
    jbhca12
    Icon for Helper I rankHelper I
    5 years ago

    Thanks, I think I have it all set. I ended up duplicating some buttons and images to handle both cases as well as a bookmark for each case depending on what the user selected...user selecting predefined date range or custom date range...and then closing the slicer panel. A bit of a pain and would have rather controlled it using a couple of measures and some overlays but that would only work when the slicer pane was open. For some reason when opening a closed slicer panel the measure checking for the use of the custom date range would be ignored so the button and slicer would not change accordingly. Ah well, I guess you get what you get when you don't have complete control over coding a solution.

    Thanks for all of the help...I think I have what I need for now! Much appreciated!