Dashboard Mode - Mark as date table
Business Question
How can we use a date table marked properly in Power BI to analyze sales trends over time?
0
0
Mark as date table in Power BI - Dashboard Guide
Sample Data
| Date | Sales Amount |
|---|---|
| 2024-01-01 | 100 |
| 2024-01-02 | 150 |
| 2024-01-03 | 200 |
| 2024-01-04 | 130 |
| 2024-01-05 | 170 |
| 2024-01-06 | 160 |
| 2024-01-07 | 180 |
Date Table Sample
| Date | Year | Month | Day | Weekday |
|---|---|---|---|---|
| 2024-01-01 | 2024 | 1 | 1 | Monday |
| 2024-01-02 | 2024 | 1 | 2 | Tuesday |
| 2024-01-03 | 2024 | 1 | 3 | Wednesday |
| 2024-01-04 | 2024 | 1 | 4 | Thursday |
| 2024-01-05 | 2024 | 1 | 5 | Friday |
| 2024-01-06 | 2024 | 1 | 6 | Saturday |
| 2024-01-07 | 2024 | 1 | 7 | Sunday |
Dashboard Components
- KPI Card: Total Sales
Formula:Total Sales = SUM('Sales'[Sales Amount])
Result: 1090 - Line Chart: Sales Over Time
X-axis: 'Date Table'[Date]
Y-axis: Total Sales measure
Uses the marked date table for continuous date axis - Table Visual: Sales by Weekday
Columns: 'Date Table'[Weekday], Total Sales measure
Shows sales grouped by weekday using the date table
Dashboard Layout
+----------------------+----------------------+ | KPI Card | Line Chart | | Total Sales (1090) | Sales Over Time | +----------------------+----------------------+ | Table: Sales by Weekday | +----------------------------------------------+
Interactivity
The date table is marked as a date table in Power BI using the Mark as Date Table feature with the Date column selected. This allows the line chart and table visual to use the continuous date axis and proper date hierarchies.
Filters or slicers on the date table (like Year or Month) will update all visuals because the sales data is related to the date table by the Date column.
Self Check
If you add a slicer filtering the Year = 2024 on the date table, which components update?
- The KPI Card showing Total Sales updates to show sales only for 2024.
- The Line Chart updates to show sales over time only within 2024.
- The Table visual updates to show sales by weekday only for 2024 dates.
Key Result
Dashboard showing total sales and sales trends over time using a marked date table for accurate time analysis.