Transpose operations in Power BI - Dashboard Guide

Dashboard Mode - Transpose operations

Dashboard Goal

This dashboard helps you see sales data by switching rows and columns. It answers: How do sales numbers look when we flip the data layout?

Sample Data

Product	Q1 Sales	Q2 Sales	Q3 Sales
Apples	100	150	200
Bananas	80	120	160
Cherries	90	110	130

Dashboard Components

• Original Sales Table: Shows sales by product and quarter as given.
• Transposed Sales Table: Shows quarters as rows and products as columns. This flips the original table.
• Total Sales per Product: A card showing total sales for each product using DAX:

  Total Sales Apples = CALCULATE(SUM(Sales[Q1 Sales]) + SUM(Sales[Q2 Sales]) + SUM(Sales[Q3 Sales]), Sales[Product] = "Apples")
  Total Sales Bananas = CALCULATE(SUM(Sales[Q1 Sales]) + SUM(Sales[Q2 Sales]) + SUM(Sales[Q3 Sales]), Sales[Product] = "Bananas")
  Total Sales Cherries = CALCULATE(SUM(Sales[Q1 Sales]) + SUM(Sales[Q2 Sales]) + SUM(Sales[Q3 Sales]), Sales[Product] = "Cherries")

• Transpose Logic Explanation: Using Power BI's "Unpivot Columns" feature or DAX functions like SELECTCOLUMNS and UNION to reshape data from wide to long format, then pivot back to transpose.

Dashboard Layout

+----------------------+-------------------------+
| Original Sales Table  | Total Sales per Product |
|                      |                         |
+----------------------+-------------------------+
|       Transposed Sales Table                 |
+---------------------------------------------+

Interactivity

Adding a slicer for Product filters both the Original Sales Table and the Transposed Sales Table to show only selected products. The Total Sales cards update to show totals for the selected product(s).

Self Check

If you add a filter to show only Bananas, which components update and what do they show?

• Original Sales Table: Shows only Bananas row.
• Transposed Sales Table: Shows only Bananas sales by quarter as rows.
• Total Sales per Product: Shows total sales for Bananas only.

Key Result

Dashboard showing sales data transposed from products as rows to quarters as rows, with interactive filtering by product.