Default Selection

The default selection is an advanced feature that helps you keep certain values automatically selected when the filter is first opened or the page is refreshed. There are two ways you can apply the default selection option:

  1. Fixed

  2. Based on Field

Fixed option:

To create a default selection using the Fixed option, follow these steps:

  1. Open advanced settings from the "⚙️" button.

  2. Go to the Default Selection section.

  3. Select Fixed, choose the level, and provide the value for selection.

Based on Field option:

To create a default selection based on a field, follow these steps:

  1. Create a column or measure in your data.

  2. Use a 0/1 condition, where 1 represents true and 0 represents false.

  3. Add the measure to the Default Selection Field.

  4. Now go to the advanced settings "⚙️" > Default Selection > Based on Field > Select the measure created > Hit Apply.

Default Selection = 
SWITCH(
'Electronic List'[Selected measure], 
    "MacBook Air", 1, // 1 for values to be selected
    "ASUS ZenBook", 1, 
    "HP Spectre x360", 1,
0                    // 0 for values which should not be selected
)

Last updated