Forum Discussion
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 slicer based on Ship Date where I have set a bunch of preset date periods along with a "Custom" selection. If the user selects "Custom", then a date range slicer below will enable and allow the user to use a slider and select their own custom date range. So far, so good.
If the user decides to go back and select a preset date period, the date range slicer should disable. However, if they made any change to the default date on that date range slicer, one or both of the actual date fields on the slicer remain enabled if the user goes back and selects a preset date period.
The user has to actually select the "Clear selections" icon on the date range slicer in order to fully disable those date fields. Does anyone know a way to force the slicer to fully disable?
Thanks!
JB
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
11 Replies
Hi jbhca12 ,
This happens because of the way the slicers and overall filtering works that "saves" the latest information.
I believe that the best option instead of having the option custom on the slicer is to have two bookmarks one that shows the two slicers and then one that turns off the date periods and resets the range to the full data, in this cases you just need to be aware that one will ahve the Data option turn on and the other is off so that the slicer can reset to the initial values.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks
I'm not sure I understand how you "turn off" a slicer with a bookmark? I don't think I can just disable the date periods slicer when the user selects "Custom", even if "Custom" is not a choice in the date periods slicer but an image you click on.
I like the fact that I can control the date range slicer with a filter that tells it to only show the items in the slicer when the filter value is 1, which is when the user selects "Custom" from the date period list. I just don't understand why, when the user selects something other than "Custom" from the date period list that it doesn't follow the same filter and NOT show the items in the date range slicer.
If you have a solution, can you be a bit more specific as to how you would address it? I've tried what you suggested but have no way of disabling the date periods list and no idea which bookmark you suggest should have data checked and which one should not?Hi jbhca12 ,
I got lost at something you said in the previous post:
jbhca12 wrote:
I just don't understand why, when the user selects something other than "Custom" from the date period list that it doesn't follow the same filter and NOT show the items in the date range slicer.
You want the slicer to be adjusted accordingly to the dates of the previous selection?
How do you have the slicers setup? and the filterings?
