Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 can manually change the date and write future dates.
Is it possible to block somehow the date slicer to only allow the user to select dates in the filtered dates I want to?
Thank you very much
Hi @ilana105,
This is by design. When the slicer is created, it uses the date range of the data. You can the explicitly change the min or max. This is allowed so that user can set a custom window if he/she knows the range of dates in data can change.
Best Regards,
Qiuyun Yu
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.
Best Regards,
Dale
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
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
Hi @ilana105,
You are welcome. It's by design according to the reply of the Product Team.
Best Regards,
Dale
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.
Is this a useability issue or a true security issue? In other words, do you have future dates and data that you don't want users to see or ?
Hello @Greg_Deckler
It is more a useability issue, because this might let the users think that they have future dates when they haven´t. However, in the future this might be a security issue
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |