Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Disabling/Excluding Slicer Function for End User

Hi All,   I have a report which shows several metrics related to service events. One of the slicers used is a date filter which allows our end users to filter based on the date in which the service...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Very dependent on use case, you could potentially create a measure which ignores the slicer but not sure if you want this for all users, particular users, all the time, some of the time. A nice note on the report or a comment in the Service might go a long way towards user education?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Greg,

 

Unfortunately, I don't think that will work with my situation. We have records such as:

ID     Upload Date     Summary     Update Date

1       11/15/2019       Event           11/20/2019

2       11/15/2019       Event           

3       11/15/2019       Event           11/21/2019

4       11/15/2019       Event           11/18/2019

5       11/15/2019       Event          

 

Our users need the ability to filter on both Upload Date and Update Date. Because of this, I have slicers for each, allowing the user to enter a date range. However, if they want to see all events that were uploaded on 11/15, they cannot do this. They can select that date range for that slicer, however, since two of the records have yet to be updated, regardless of the date range they enter for Update Date, those two "new" events do not show in the result set.

 

Thanks,

Matt