Presets
Last updated
Last updated
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:
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.
This contains the list of presets to show on the side panel. Click the preset tag and hit “Apply” to save.
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.
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."