Possible to allow end users to enter minimum value that filters table visual?

[ERing]

I have a report with a table visual like below. The purpose of the report is to allow the end user to analyze data for specific employees (technicians).

My end users have requested a way to filter the results in the table using a minimum value for "Total Hours". The goal is for them to have a way to enter the desired minimum "Total Hours". For example, the end user may only want to see Technicians that have a total of 19,000 or more hours. In this example, any technicians that have less than 19,000 Total Hours would be filtered from the visual. 

The minimum number of "Total Hours" can very greatly depending on how large of date range is selected in the date filter. For example, if they select only a 7 day date range, the minimum "Total Hours" may be 25.

I believe this should be possible, but I haven't found a way to accomplish this.

SAMPLE FILE 

[Irwan · Accepted solution]

hello @ERing 

i think you can utilize filter pane.

i saw you did not hide the filter pane, so user should be able to use that as well.

Hope this will help.

Thank you.

[ullassl1991 · Accepted solution]

Hi @ERing , if you want to create a slicer for "Total Hours" with range of numbers please go through this video 
https://www.youtube.com/watch?v=AZAL-QPn5Zc 

[ERing]

@ullassl1991 This works. Thank you.

[Irwan · Accepted solution]

hello @ERing 

i think you can utilize filter pane.

i saw you did not hide the filter pane, so user should be able to use that as well.

Hope this will help.

Thank you.

[ERing]

@Irwan I will most likely end up hiding the filter pane. This would work if the filter pane isn't hidden as you mentioned. Thank you.