# Dates

A few date setting can be changes in the **Dates** section.

<figure><img src="/files/WbcQf07IakCpG2A7qwcV" alt=""><figcaption><p>Date settings</p></figcaption></figure>

### Dates across cards

By default, the big numbers and the last mark of the time series chart **show values for the most recent date across all periods**. In case that there is no data for this period for all cards, you can select the option to show the latest available date per card.&#x20;

### Number of periods in chart

Define the number of periods shown in the charts. The charts will adjust nicely depending on the selected number of periods.

### Date format for axis labels

Depending on the selected datepart or datetrunc for the time series chart, axis labels need to be adjusted. While the extension smartly changes the format when dragging on the date field, you can specify the label here. There, use the following logic to get your desired label formats:

* **%b**: Abbreviated month (e.g., Jan, Feb)
* **%m**: Month as a number (01–12)
* **%y**: Year (last two digits, e.g., 23 for 2023)
* **%Y**: Full year (e.g., 2023)
* **%d**: Day of the month (01–31)
* **%U**: Week number (starting from Sunday)
* **%q**: Quarter (1–4)

Example Formats:

* **%b-%y** → *Jan-23* (Month-Year)
* **%Y-%m-%d** → *2023-09-30* (Year-Month-Day)
* **%y-w%U** → *23-w40* (Year-Week Number)
* **%Y-Q%q** → *2023-Q3* (Year-Quarter)

### Show label on X-Axis

Selecting 'Hide' will hide the labels on the x-axis.

### Period flag

By default, the Big Number on the KPI cards shows the last value from the time series chart. You can get more control over this by using period flag. This flag has to be an **boolean attribute (true/false)** like

**ATTR**(DATETRUNC('month',\[Order Date])=\[Month Parameter]).

Drag this field to Detail, and map map it in the Period Flag dropdown.

<figure><img src="/files/bhKUpv5E9b4yQhWo7gdc" alt=""><figcaption></figcaption></figure>

This feature is for example useful, when you want to roll up the current year against the last year, and use the datepart of month as the datefield. A visual indicator will also be added in the trend chart to highlight the period that is being shown on the big number.

<figure><img src="/files/0UdUTIWenv6Vg8vYjCc7" alt=""><figcaption></figcaption></figure>

Period Flags can be metric-specific, except for the decomposition tree.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.infotopics.com/powerkpis/features/style-kpi-cards/global-settings/dates.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.