Performance Analyzer in Power BI - Dashboard Guide

Dashboard Mode - Performance Analyzer

Dashboard Goal

This dashboard helps you understand how fast your Power BI report visuals load. It shows the time each visual takes to display data so you can find and fix slow parts.

Sample Data

Order ID	Product	Category	Sales Amount	Order Date
1001	Chair	Furniture	150	2024-01-10
1002	Desk	Furniture	300	2024-01-15
1003	Pen	Office Supplies	20	2024-01-20
1004	Notebook	Office Supplies	45	2024-01-25
1005	Monitor	Technology	400	2024-01-30
1006	Keyboard	Technology	80	2024-02-05

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM('Sales'[Sales Amount])
  Result: 995
• Bar Chart: Sales by Category
  Shows total sales for each product category.
  Formula: Sales by Category = SUM('Sales'[Sales Amount]) grouped by Category
• Performance Analyzer Table: Visual Load Times
  Shows how long each visual took to load in milliseconds.
  Sample Data:
  

  Visual Name	Load Time (ms)
  Total Sales KPI	120
  Sales by Category Chart	350
  Sales Data Table	200

• Table: Sales Data
  Shows raw sales data for reference.

Dashboard Layout

+----------------------+-------------------------+
|      Total Sales      |   Sales by Category     |
|       (KPI Card)      |        (Bar Chart)      |
+----------------------+-------------------------+
|      Performance      |      Sales Data Table   |
|   Analyzer Table      |                         |
+----------------------+-------------------------+

Interactivity

Applying a date filter (e.g., only show orders from January 2024) updates all visuals:

• Total Sales KPI recalculates total sales for filtered dates.
• Sales by Category Chart updates bars to show sales only for filtered dates.
• Sales Data Table shows only rows matching the filter.
• Performance Analyzer Table updates load times reflecting the filtered visuals' performance.

Self Check

If you add a filter for Category = Technology, which components update and how?

• Total Sales KPI: Shows total sales only for Technology products (Monitor + Keyboard = 480).
• Sales by Category Chart: Displays only the Technology category bar with sales 480.
• Sales Data Table: Shows only rows with Category Technology.
• Performance Analyzer Table: Updates load times to reflect the visuals rendering only Technology data, possibly faster load times.

Key Result

Dashboard showing sales totals and category sales with visual load times to analyze report performance.