"Slicers" are basically small visual tools that allow data to be quickly scanned and refined, allowing you to find what you are after.
Advanced Search Tool
Enter 1 or more lines with criteria
Click the funnel icon at bottom right
The Filter mode supports textual fields, dates, and numbers.
For each data type you can use specific operators such as < or > for numbers and dates, or “quotes” for strings.
Here are some examples:
Use “text” to retrieve all strings equal to text
Use text to retrieve all strings containing the word text
Use text* to retrieve all strings starting with the word text
Use >2018-02 to retrieve all dates after Feb 2018
Use <2018 to retrieve all dates prior to 2018
Use 2017-02_2018-02 to retrieve a time period between Feb 2017 and Feb 2018
Use >=45 to retrieve all numbers greater than or equal to 45
Use !45 to retrieve all numbers other than 45
