Measure/Numeric Filter

The Measure/Numeric Filter allows you to dynamically filter data based on numerical ranges, customize slider functionality, and tailor the appearance to fit your visual design.

Numeric Filter

1. In the Visualizations pane, add a numeric column to the "Category" data field. Once the data is populated, a measure slider will automatically appear.

2. Use the slider for quick adjustments or manually input specific values in the text boxes for precise filtering. This is especially useful when slicing data by specific numbers.

Image 1: Numeric Colum when added in Category field

Numeric Filter cannot be combined with other filter types. If multiple columns are added, the visual will automatically switch to other modes.

Measure Filter

With Measure Filter, selecting a range dynamically filters the items based on the chosen values:

1. With Categorical data populated in the "Category" data field, add numeric data (measure or column) to the "Others" field in the Visualizations pane. A slider automatically appears in the visual.

2. Drag the slider to select a specific range which dynamically updates the filter, automatically selecting items within the chosen range.

3. To enable or disable the slider, navigate to the Measure Filter section under the Format Visual settings.

Image 2: Revenue Measure Slider in Hierarchy Filter.

Image 3: Revenue measure slider in Facet Filter when Show fixed label is disabled.

In Facet Mode, Measure Filter is supported only for one column

DAX Measures are supported only in the "Others" data field

Format Pane Settings

Configure General section under measure filter settings with the following options:

1. Range:

   • Between: Filter data within a specified range.

   • Less than or equal to: Include values below or equal to the selected value.

   • More than or equal to: Include values above or equal to the selected value.

2. Step

   • Use the Step option to set increments size for the slider that make sense for your data.

3. Show Label

   • Use the toggle button to enable or disable the visibility of the measure label in the visual.

Image 4: Measure Filter General Settings

Configure Slider Style section under measure filter settings with the following options:

1. Slider Color: Choose the color of the slider.

2. Slider Background Color: Adjust the background color behind the slider.

3. Label Color: Set the color of the measure label.

4. Font Color and Font Style Settings: Modify the font color, size, and style.

5. Drag Handle Color: Select the color of the slider handle used to adjust values.

At the bottom left of the tile, you’ll find the Reset to Default option. Click this to revert all Measure Filter settings to their original configuration.

Image 5: Slider Style Settings