Interface overview (Report, Data, Model views) in Power BI - Dashboard Guide

Dashboard Mode - Interface overview (Report, Data, Model views)

Goal

This dashboard helps you understand the three main views in Power BI: Report, Data, and Model views. It shows what each view is for and how they connect to build a complete report.

Sample Data

Product	Category	Sales	Quantity
Notebook	Stationery	120	10
Pen	Stationery	80	20
Chair	Furniture	300	5
Desk	Furniture	450	3
Monitor	Electronics	600	4
Keyboard	Electronics	150	7

Dashboard Components

• KPI Card - Total Sales: Shows total sales amount.
  Formula: Total Sales = SUM(Sales[Sales])
  Result: 1700
• Bar Chart - Sales by Category: Visualizes sales grouped by product category.
  Formula: SUM(Sales[Sales]) by Sales[Category]
• Table - Raw Data View: Displays the sample data as is for detailed inspection.
• Model View Diagram: Shows relationships between tables (in this case, a single Sales table). This view helps understand data structure.
• Report View Explanation: Text box explaining that this is where visuals like charts and cards are created and arranged.
• Data View Explanation: Text box explaining that this view shows the raw data in table format for checking and cleaning.
• Model View Explanation: Text box explaining that this view shows how tables relate and helps create relationships.

Dashboard Layout

+-----------------------------+-----------------------------+
|        KPI Card: Total Sales |  Bar Chart: Sales by Category |
+-----------------------------+-----------------------------+
|  Table: Raw Data View        |  Text: Report View Explanation|
+-----------------------------+-----------------------------+
|  Text: Data View Explanation |  Text: Model View Explanation |
+-----------------------------+-----------------------------+
|           Model View Diagram (full width)              |
+--------------------------------------------------------+

Interactivity

Filters or slicers applied in the Report view (like selecting a category) update the KPI card and bar chart to show filtered results. The Table view also updates to show only filtered rows. The Model view remains static as it shows data structure.

Self Check

If you add a filter to show only the 'Furniture' category, which components update?

• KPI Card: Total Sales updates to show sales only for Furniture (300 + 450 = 750).
• Bar Chart: Sales by Category updates to show only Furniture category bar.
• Table: Raw Data View updates to show only rows with Furniture category.
• Model View Diagram: Does not change because it shows data structure, not data content.

Key Result

Dashboard explaining Power BI's Report, Data, and Model views with sample sales data and visuals.