Measure Filter

PreviousHierarchy Filter NextNumeric Filter

Last updated 15 days ago

Measure Filter

The Measure Filter allows you to dynamically filter data using DAX measures, typically applied with categorical fields to refine insights based on calculated values.

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

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.
Drag the slider to select a specific range which dynamically updates the filter, automatically selecting items within the chosen range.
To enable or disable the slider, navigate to the Measure Filter section under the Format Visual settings.

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:

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.
Step: Use the Step option to set increments size for the slider that make sense for your data.
Label: Use the toggle button to enable or disable the visibility of the measure label in the visual.

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

Fixed Label: When enabled, displays a fixed label for typing the start and end range.
Slider Color: Choose the color of the selected range of the slider.
Border Color: Select the color for the unselected portion of the slider range.
Background Color: Adjust the background color behind the slider.
Drag Handle Color: Set the color of the measure label.
Font Color and Font Style Settings: Modify the font color and style to Italics, Bold and Underline.
Font Size: Customize the font size of values shown in the alpha numeric filter.

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.

PreviousHierarchy Filter NextNumeric Filter

Last updated 15 days ago

The Measure Filter allows you to dynamically filter data using DAX measures, typically applied with categorical fields to refine insights based on calculated values.

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

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.
Drag the slider to select a specific range which dynamically updates the filter, automatically selecting items within the chosen range.
To enable or disable the slider, navigate to the Measure Filter section under the Format Visual settings.

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:

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.
Step: Use the Step option to set increments size for the slider that make sense for your data.
Label: Use the toggle button to enable or disable the visibility of the measure label in the visual.

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

Fixed Label: When enabled, displays a fixed label for typing the start and end range.
Slider Color: Choose the color of the selected range of the slider.
Border Color: Select the color for the unselected portion of the slider range.
Background Color: Adjust the background color behind the slider.
Drag Handle Color: Set the color of the measure label.
Font Color and Font Style Settings: Modify the font color and style to Italics, Bold and Underline.
Font Size: Customize the font size of values shown in the alpha numeric filter.

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.