Presets

Presets are pre-defined time ranges that make it easy for users to select specific periods without manually choosing dates. These presets include commonly used time ranges like "today," "tomorrow," "this week," "next week," "this month," "next month," and more. They simplify the process of selecting dates by offering predefined options.

By default, presets are enabled. You can toggle it on/off.

The Preset section in the advanced settings consists of three parts:

Preset Style​

In this section, you can customize the appearance of the side panel for presets:

• Choose whether to position the preset panel on the left or right side.

• Adjust the text size and font family.

• Apply formatting options like bold, italic, and underline.

• Modify the text and background colors for different states such as default, selected, and hover over.

• Control the formatting of the input days box.

Default Presets​

This contains the list of presets to show on the side panel. Click the preset tag and hit “Apply” to save.

Preset Tags	Description
Today	Select the current date irrespective of the dataset.
Yesterday	Select the yesterday date irrespective of the dataset.
Max Date	Select the latest date from the given data.
This Week	Select the current week irrespective of the dataset.
Last Week	Select the previous week based on the current week.
Max Week	Selects the latest week available in the given data.
This Month	Select the current month irrespective of the dataset.
Last Month	Select the previous month based on the current month.
Max Month	Select the latest month available in the given data.
Last Quarter	Select the previous quarter based on the current quarter.
Max Quarter	Select the latest quarter available in the given data.
QTD	Select the all the dates from start of current quarter to today.
YTD	Select the all the dates from start of current year to today.
Custom	Create a Preset based on date of your choice.

TIP

The "Today" and "Yesterday" presets are particularly useful for obtaining a daily status view in reports where new data is regularly uploaded.

Custom Presets​

Use this option to add custom presets to the list.

Follow the below instructions to add a custom preset.

1. Create a column or measure in your data.

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

   • This column can be created in your source data, Power Query Editor, Calculated Column, or using DAX formula.

DAX Measure Example

VAR _date = MIN('Date'[Date])

VAR Result = 
        IF(_date = BLANK(), BLANK(), 
            SWITCH(TRUE(),
                _date = DATE(2022, 12, 10), 1,  // 1 for true dates
                _date = DATE(2022, 01, 22), 1,
                0)                              // 0 for false dates
        )
    
RETURN
Result 

Refer to this link for information on adding a custom column.

1. Drag the custom column into the presets field.

   • Ensure that the column is of numeric type.

   • If it's a column, choose either MIN or MAX as the aggregation type.

2. Go to advanced settings > presets > custom presets.

3. Click the “+” button to add a new preset.

4. Choose the field from the dropdown and tag it for preset.

5. Save the preset and hit “Apply”.

Custom presets will appear at the bottom of the preset list. To test them, simply select the desired custom preset and click "Apply."