Header promotion in Power BI - Dashboard Guide

Dashboard Mode - Header promotion

Business Question

How can we convert the first row of data into column headers to make the table easier to read and analyze?

Sample Data (Before Header Promotion)

Column1	Column2	Column3
Product	Sales	Region
Apple	100	East
Banana	150	West
Cherry	200	East
Date	120	West

Dashboard Components

1. Original Table Visual

Shows the raw data as imported, with the first row as data, not headers.

2. Transformed Table Visual (After Header Promotion)

Table after promoting the first row to headers, making columns: Product, Sales, Region.

Power Query Step: Use Table.PromoteHeaders(Source) to convert first row to headers.

3. Total Sales Card

Shows total sales sum from the transformed table.

DAX Measure: Total Sales = SUM('PromotedTable'[Sales])

Result: 570 (100 + 150 + 200 + 120)

4. Sales by Region Bar Chart

Bar chart showing total sales grouped by Region.

Data: Uses 'PromotedTable' with columns Product, Sales, Region.

Dashboard Layout

+----------------------+-----------------------+
| Original Table       | Transformed Table      |
| (Raw Data)           | (Headers Promoted)     |
|                      |                       |
+----------------------+-----------------------+
| Total Sales Card                         |
| (Sum of Sales)                          |
+----------------------------------------+
| Sales by Region Bar Chart               |
|                                        |
+----------------------------------------+
    

Interactivity

Adding a slicer for Region filters both the transformed table, total sales card, and the sales by region bar chart simultaneously.

This allows users to see sales data and totals for selected regions only.

Self Check

If you add a filter for Region = East, which components update and what is the new total sales?

• The transformed table shows only rows with Region = East (Apple and Cherry).
• The total sales card updates to 300 (100 + 200).
• The sales by region bar chart updates to show sales only for East region.
• The original table visual does not update because it is raw data without proper headers.

Key Result

Dashboard demonstrating how promoting the first row to headers improves data clarity and enables accurate sales analysis by region.