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.
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.
Refer to this link for information on adding a custom column.
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.
Go to advanced settings > presets > custom presets.
Click the “+” button to add a new preset.
Choose the field from the dropdown and tag it for preset.
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."
Last updated