Inforiver
Super Filter
Super Filter
  • Introduction to Inforiver Super Filter
    • Getting Started
      • Installing from AppSource
      • Quick Mode
  • Filter Types
    • 1. Date Filter
      • Date Slider
        • Date Format
        • Max Default Date
      • Calendar Modes
        • Year | Multi Year
        • Month Range
          • Single Date Range
          • Multiple Date Range
          • Predefined Date Range
        • Month
          • Month Calendar Options
        • Week
        • Day
      • Relative Date
      • Dynamic Date Presets
      • Variance
      • Calendar Heatmap
        • Annual Calendar Heatmap
      • Format Pane Settings
        • Week Mode & Calculation
        • Default Selection
        • Initial Start Date & Start day of Week
        • Single Select
        • Days Off
        • Fiscal Month Support
        • Measure Values & Sum Time Period Values
        • Calendar Control
        • Holidays
        • Invalid Dates
        • Month Total Bar
        • Background Color & Opacity Control
      • Calendar Formatting Options
    • 2. Facet Filter
      • Configuring Facet Filter
        • View Type
        • Features
        • Category Style
      • Enhanced Features in Facet Filter
        • Image Filter
        • Text Area (AND/OR Support)
        • Edit Data
        • Date in List View
        • Hierarchical data Support
    • 3. Hierarchy Filter
    • 4. Measure Filter
    • 5. Numeric Filter
    • 6. Alpha Numeric Filter
    • 7. Tree Map Filter
    • 8. Play Axis
      • Multilevel Selection
  • Features
    • 1. Saved Filter
    • 2. Search
      • Wildcard Search
      • Operator based Measure Filter search
      • Focused Text Filter
      • Auto Complete
    • 3. Mass Filter
    • 4. Pop-Up Mode
    • 5. Presets
      • Conditional Formatting Presets
      • Saved Filter Presets
      • Measure Based Presets
      • Rank Based Presets
      • Customization Options
      • Formatting Options
    • 6. Conditional Formatting
    • 7. Sorting and Ranking
    • 8. Variance
    • 10. Number Formatting
    • 11. Display Settings
      • Show Details
      • Default Selection via Boolean Measure
      • Opacity Control
      • Forced Selection
      • Other Options
      • Tooltips
      • Localize Keywords
      • Hover & Selected State
    • 12. Tool Bar
    • 13. Context Awareness
  • Tips & Tricks
    • 1. Sync Slicer
    • 2. Report Page Tooltip
    • 3. Field Parameters
    • 4. Calculation Group
    • 5. Dynamic Format string measure
    • 6. Bookmark
    • 7. Edit Interactions
  • FAQs
  • Release Notes
    • Super Filter v5.5.0.0
    • Super Filter v5.4.0.0
    • Super Filter v5.2.0.0
    • Super Filter v5.1.0.0
    • Super Filter v5.0.0.0
    • Super Filter v4.5.0.0
    • Super Filter v4.0.0.0
    • Super Filter v3.0.0.0
    • Super Filter v2.0.0.0
    • Super Filter v1.0.0.0
Powered by GitBook
On this page
  • Steps to configure Default Selection using Boolean Measure
  • Example:
  1. Features
  2. 11. Display Settings

Default Selection via Boolean Measure

PreviousShow DetailsNextOpacity Control

Last updated 3 months ago

The Default Selection via Boolean Measure allows users to configure default selections in the visual using a Boolean or integer measure. This is particularly useful for tailoring reports to specific roles or regions. For example, when a regional manager opens the report, it automatically filters the data to display only the areas relevant to them.

Steps to configure Default Selection using Boolean Measure

  1. Add a Boolean or Integer Measure with specific conditions to the Others Field in the visual.

  2. Enable Default Selection:

    • Go to the Display Settings in the Format Pane.

    • Locate the Default Selection option.

    • Select the previously added measure to configure default selections.

  3. Once selected, the visual will dynamically apply the default filter based on the conditions defined in the measure. This ensures that relevant selections are made automatically when the report is accessed.

  4. In read mode, using the Default Selection measure allows the visual to revert to the predefined default selection when Reset Filters is clicked, restoring the original state ensuring a consistent starting point.

Example:

In this example, the user wants to automatically select Bikes and Accessories for the Europe sales territory, and Clothing for North America. To achieve this, a DAX measure is created as follows:

Default Selection = 
SWITCH(
    TRUE(), 
    AND(VALUES(SalesTerritory[Group]) = "Europe", 
        OR(VALUES('Product'[Category]) = "Bikes", 
           VALUES('Product'[Category]) = "Accessories")
    ), 1,
    AND(VALUES(SalesTerritory[Group]) = "North America", 
        VALUES('Product'[Category]) = "Clothing"
    ), 1,
    0
)

If the SalesTerritory[Group] is "Europe" and Product[Category] is "Bikes" or "Accessories," or if the group is "North America" with Product[Category] as "Clothing," it returns 1 to select them. All other items remain unselected (0).

Once configured in the Default Selection under Display Settings, the visual highlights the specified items automatically.

Video 1: Default selection configuration and read view behavior
Image 1: Default Selection in format pane