Sales Dashboard Walkthrough

Power BI · Projects & Case Studies

Theory

This walkthrough builds the course's sample sales report end to end. The business wants to know total sales, which regions and products lead, and how sales trend by month. The data is three tables: Sales (OrderID, OrderDate, CustomerID, ProductID, Region, Qty, Amount), Customers (CustomerID, Name, City, Segment) and Products (ProductID, Product, Category, Price), plus a DAX 'Date' table.

After loading and typing the columns in Power Query, you relate the dimensions to Sales, mark the Date table, and write the core measures. With the six sample orders the KPI cards read Total Sales ₹6,200, Orders 6, Total Qty 10 and Avg Order Value ₹1,033.33, and the top region is North with ₹3,200. The Overview page shows these cards, a monthly trend (Jan ₹1,200, Feb ₹2,300, Mar ₹2,200, Apr ₹500), a region bar chart and a category matrix. A drill-through Customer page shows each customer's orders, and the report is published and shared as an app.

Why we use it

Seeing every step in one connected example shows how Power Query, modeling, DAX and visuals depend on each other, which isolated lessons cannot.

When to use it

Follow this walkthrough after the earlier sections, then rebuild it on your own dataset. Use it as a template for interview take-home tasks, which usually ask for exactly this kind of small sales dashboard.

How it works

  1. Business asks for a sales dashboard
  2. Load and clean Sales, Customers, Products
  3. Create the Date table and relationships
  4. Write core measures and check totals
  5. Design Overview and drill-through pages
  6. Do totals match the source (₹6,200)? Yes: Publish and share as an app. No: Debug measures and relationships.
  7. Dashboard in users' hands

Syntax

Steps:
1. Get data → Text/CSV ×3 → Transform data (types, trim)
2. Modeling → New table: Date = CALENDAR(...) → Mark as date table
3. Model view: Customers 1→* Sales, Products 1→* Sales, Date 1→* Sales
4. Home → New measure (core KPIs)
5. Build pages → Publish → Create app

Example

Total Sales     = SUM(Sales[Amount])                         // 6,200
Orders          = DISTINCTCOUNT(Sales[OrderID])              // 6
Total Qty       = SUM(Sales[Qty])                            // 10
Avg Order Value = DIVIDE([Total Sales], [Orders])            // 1,033.33
Top Region      = 
    CONCATENATEX(
        TOPN(1, VALUES(Sales[Region]), [Total Sales]),
        Sales[Region], ", "
    )                                                         // North

Page 1 Overview: 4 cards, line chart by 'Date'[Month], bar chart by Region, matrix Category → Product
Page 2 Customer Detail: drill-through on Customers[Name]

Key points

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic