Forum Discussion

jbhca12's avatar
jbhca12
Helper 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

     

     

     

MFelix's avatar
MFelix
Super User
5 years ago

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?

 

 

jbhca12's avatar
jbhca12
Helper I
5 years ago

I have a "Date Periods" table that the "Ship Date Periods" is associated with.

The "Date Periods" table contains date, type and order columns. This is the filter for the "Ship Date Periods" slicer.

When selecting anything other than "Custom" from the "Ship Dates Period" slicer, the following slicer is disabled...

The above slicer is related to my "Date" table which contains all of the dates available via the following DAX:

Date =
CALENDAR(
MIN(Bookings[Create Date]),
TODAY()
)
 
This "Date" table contains a measure called "Date Slicer Filter" with the following DAX:
Date Slicer Filter =
IF(
SELECTEDVALUE('Date Periods'[Type]) = "Custom",
1,
0
)
 
So the filter on the date range slicer looks as follows:

So when someone selects "Custom" from the "Ship Date Period" slicer, the date range slicer will enable:

The problem is that if someone changes either date in the above slicer and then decides to click something other than "Custom" in the "Ship Date Periods" slicer, depending on which date changed from the original dates (1/2/2018 and 5/11/2021 in this example) in the date range slicer, when the Date Slicer Filter is reapplied based on the value now being 0 and not 1, the date range slicer disables, but one or both of the date fields on that slicer remain enabled and impacts the date selection for the report until the user physically clears the selections from that slicer...

 

 

Clicking the red circled "Clear selections" icon above results in what I would like to see (below) 

 

 

This is my current dilemma. I don't think controlling this using bookmarks is going to work.

If you want to see the YouTube video that this whole approach is based on, here it is.

https://www.youtube.com/watch?v=fKygF7VEJnQ&t=403s


  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi jbhca12 ,

     

    To what I can see from the video there is the used of a dimension table with the several dates and time ranges and the bidirectionality between both tables that will give you the filtering of the calendar table witouth the impact of the slicer in the other calculations. 

     

    Are you using that table or just making it trough a filter only (0 and 1)?

     

    If you are making it trough a filter the output will be different since the slicer will be always connected with the date table and your calculation will be impacted by the selection on the slider.

     

    Sorry for continuing to make question but just want to understand your model in order to give you the best answer possible.

    • jbhca12's avatar
      jbhca12
      Helper I
      5 years ago

      I'm doing it exactly as it is in the video. Filtering isn't the issue. Getting the range slicer to completely disable is the issue. If a user selects something other than "Custom" in the date period slicer, and if they made ANY changes to the default dates in the date range slicer, it will keep those two date inputs enabled. The rest of the slicer will disable as expected.

      • MFelix's avatar
        MFelix
        Super User
        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