Forum Discussion

ilana105's avatar
ilana105
Icon for Helper I rankHelper I
8 years ago

Block the user to enter some dates in date filter

Hello all,   I have a date slicer in a report page and I have the relative page filter to show only date from two years ago until today (included). The thing is that if I select the date slicer I c...
General Comment
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi ilana105,

 

Maybe there is workaround. You can use two slicer and hide one slicer with Selection if the users don't have Edit access. Maybe the previous "if" condition isn't necessary if you are pursuing the convenience rather than security. And one more step is making sure the hidden slicer only filter the visible slicer.

Block_the_user_to_enter_some_dates_in_date_filter

 

 

Best Regards,

Dale

ilana105's avatar
ilana105
Icon for Helper I rankHelper I
8 years ago

Hello v-jiascu-msft

 

Thanks for your answer! I found out the selection pane and have created another slicer to hide. I have edited the interactions but I still can select future dates in the previous slicer

 

 

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Use the drop down to change the slicer type from Between to After or Before or perhaps Relative. Might provide a less confusing interface for users.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi ilana105,

     

    I have reported this to the Product Team to investigate more. The workaround could be the idea of Greg_Deckler. I will update here later.

     

    Best Regards,

    Dale

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi ilana105,

         

        You are welcome. It's by design according to the reply of the Product Team.

         

        Best Regards,

        Dale