Master Power BI From Scratch

Learn Power BI fundamentals, data sources, data transformation, data modeling, DAX, visualizations, reports, and dashboards through structured practical lessons.

COURSE SYLLABUS
1. Power BI Introduction
Introduction to Power BI Power BI Desktop and Service Power BI Workflow Power BI Terminology Power BI Workspace Overview
2. Power BI Installation and Interface
Power BI Installation Power BI Desktop Interface Report, Data and Model Views Power BI File Management Power BI Settings and Options
3. Power BI Data Sources
Excel and CSV Data Sources Text and Folder Data Sources Database Data Sources Web and Online Data Sources Data Source Credentials and Refresh
4. Power BI Data Transformation
Power Query Introduction Data Types and Column Operations Merge and Append Queries Split, Group and Pivot Columns Power Query Applied Steps
5. Power BI Data Cleaning
Missing and Null Values Remove Duplicates and Errors Text and Date Cleaning Replace and Fill Values Data Quality Validation
6. Power BI Data Modeling
Data Modeling Fundamentals Create Table Relationships Cardinality and Filter Direction Star Schema and Dimension Tables Date Tables and Model Optimization
7. DAX
DAX Introduction and Syntax DAX Aggregation Functions DAX Logical and Conditional Functions DAX Filter and Iterator Functions DAX Date and Time Intelligence
8. Power BI Calculations
Calculated Columns Measures and Implicit Measures Row Context and Filter Context Quick Measures and KPI Time-Based Business Calculations
9. Power BI Visualizations
Basic Power BI Charts Pie, Donut and Treemap Charts Cards, Tables and Matrices Maps and Geographic Visuals Advanced and Custom Visuals
10. Power BI Filters and Slicers
Filter Types and Filter Pane Slicers and Sync Slicers Drill Down and Drill Through Cross-Filtering and Highlighting Bookmarks and Buttons
11. Power BI Reports and Dashboards
Report Page Layout and Design Multi-Page Reports Dashboard Creation and Tiles Executive and Business Reports Report Usability and Accessibility
12. Power BI Formatting and Interactivity
Themes and Color Formatting Conditional Formatting Tooltips and Report Page Tooltips Visual Interactions and Edit Interactions Mobile Layout and Responsive Reports
13. Power BI Publishing and Sharing
Publish Reports to Service Workspaces and Apps Scheduled Refresh and Gateway Sharing and Permissions Row-Level Security and Deployment
14. Power BI Projects and Assessment
Sales Dashboard Project Student Performance Project Data Cleaning and Modeling Assignment DAX and Visualization Assessment Final Power BI Project and Assessment

Multi-Page Reports

A multi-page Power BI report organizes business information across several connected report pages. Instead of placing every chart and table on a single canvas, you can separate information into meaningful sections such as an overview, sales analysis, product performance, regional results, and detailed records.

A well-organized multi-page report helps users move from high-level performance indicators to more detailed analysis while maintaining consistent formatting, useful filters, and predictable navigation.

Learning Objectives

  • Understand why reports use multiple pages.
  • Plan report pages around business questions.
  • Create and rename report pages.
  • Organize visuals and filters on individual pages.
  • Use page navigation and consistent design patterns.
  • Understand how slicers and bookmarks can support navigation.
  • Test a multi-page report before publishing it.

1. What Is a Multi-Page Report?

A multi-page report contains multiple report canvases within one Power BI report. Each page can focus on a particular topic, audience, or level of detail. The pages can use the same data model while presenting different combinations of visuals and filters.

Multi-Page Report Structure

Power BI Sales Report Overview Key metrics Sales Analysis Trends Products Regions Each page answers a different business question.

2. Why Use Multiple Report Pages?

A single page can become crowded when too many visuals are added. Separating the content into multiple pages allows each page to focus on a smaller set of related questions.

Benefit Explanation Example
Clear organization Groups related information together. A separate page for product analysis.
Reduced clutter Prevents one page from becoming overcrowded. Move detailed tables to a dedicated page.
Audience-focused analysis Provides relevant views for different users. Executive overview and operational details.
Progressive exploration Allows users to move from summaries to details. Overview, category analysis, and product details.
Reusable data model Pages can use the same model and measures. Sales measures reused across several pages.

3. Plan the Pages Before Building the Report

Start by identifying the questions the report must answer. Create a page plan before adding visuals. Each page should have a clear purpose and should avoid repeating information without a reason.

Example Page Plan

Page 1: Sales Overview

  • Total Sales and Total Orders cards.
  • Monthly sales trend.
  • Sales by region.
  • Year and Region slicers.

Page 2: Sales Analysis

  • Sales by month and quarter.
  • Comparison between years.
  • Sales growth metrics.

Page 3: Product Analysis

  • Sales by category.
  • Top-performing products.
  • Product-level detail table.

Page 4: Regional Analysis

  • Sales by region and city.
  • Regional performance comparisons.
  • Regional targets and actual results, when available.
Planning Tip: Every page should answer a clear question. If two pages serve exactly the same purpose, consider combining them or making their different purposes more explicit.

4. Create and Rename Report Pages

In Power BI Desktop, report pages are managed using the page tabs at the bottom of the report canvas. You can add pages, rename them, and arrange them to create a logical reporting sequence.

Step-by-Step Instructions

  1. Open your report in Power BI Desktop.
  2. Use the New page control near the report page tabs to add a page.
  3. Rename the page using its context menu or rename option.
  4. Enter a meaningful name such as Sales Overview.
  5. Repeat the process for Sales Analysis, Product Analysis, and Regional Analysis.
  6. Arrange the page tabs in a logical order where supported.
  7. Add the appropriate visuals to each page.
Important: Renaming a report page can affect navigation buttons or bookmarks that refer to it. After changing page names, review and test your navigation actions.

5. Choose the Right Visuals for Each Page

A page should use visuals that fit the question being answered. Different pages can use different visual types while following the same overall design system.

Page Purpose Useful Visuals Example Question
Overview Cards, line charts, bar charts How is the business performing overall?
Trend analysis Line charts, column charts How have sales changed over time?
Product analysis Bar charts, tables, matrices Which products contribute the most sales?
Regional analysis Bar charts, maps where appropriate, tables Which regions perform best?
Detailed records Tables and matrices Which individual records contribute to the result?

6. Keep Page Design Consistent

Consistency makes a multi-page report easier to navigate. Use similar title positions, colors, fonts, number formats, and spacing across pages. Users should recognize that all pages belong to the same report.

Consistent Page Design

Overview Sales Analysis Product Analysis

The visuals differ by purpose, but the title bar, spacing, and overall page structure remain consistent.

7. Use Navigation Between Pages

Report users need a clear way to move between pages. Power BI provides report page tabs, and report authors can also use buttons with page navigation actions to create a more guided experience.

Page Navigation Options

  • Page tabs: Allow users to select pages directly.
  • Page navigation buttons: Open a selected destination page.
  • Bookmark navigation: Activate a saved report state.
  • Drill-through: Open a detail page using the selected data context.

Create a Page Navigation Button

  1. Insert a button on the report canvas.
  2. Select the button and open its formatting settings.
  3. Enable Action.
  4. Choose Page navigation as the action type.
  5. Select the destination page.
  6. Give the button a descriptive label.
  7. Test the button in the report viewing experience.
Navigation Tip: Use labels such as Overview, Sales Analysis, Product Details, and Regional Performance. Users should know where a button will take them before selecting it.

8. Use Slicers Across Multiple Pages

When users move between report pages, they may need to keep a shared selection such as Year or Region. Sync slicers can maintain selections across selected pages when configured appropriately.

Synchronize a Slicer

  1. Add a Year or Region slicer to a report page.
  2. Select the slicer.
  3. Open the View ribbon and choose Sync slicers.
  4. Review the available report pages in the Sync slicers pane.
  5. Enable synchronization for the pages that should share the selection.
  6. Configure slicer visibility for each page as required.
  7. Test the selection while moving between pages.

Shared Filter Across Report Pages

Year Slicer Selected: 2026 Overview Year 2026 Sales Analysis Year 2026 Product Analysis Year 2026

9. Manage Filters and Page Context

Not every page needs the same filters. An overview page may use Year and Region, while a product page may require Category and Product. Decide which filters should be shared and which should remain specific to a page.

Filter Type Typical Purpose Design Consideration
Shared slicer Maintain a common Year or Region selection. Synchronize only where consistent filtering is intended.
Page-specific slicer Refine the analysis on a particular page. Use labels that explain the filter's scope.
Drill-through filter Open a detail page for a selected value. Test the destination page and its filter context.
Page-level filter Apply a filter to visuals on one page. Document or label important restrictions where useful.
Important: Synchronized slicers and page-specific filters can combine to affect results. Test each page with the actual filter combinations your users are likely to select.

10. Organize Pages for Different Audiences

A single report may serve executives, managers, and operational users. Organize the pages so each audience can quickly locate the information it needs.

Example Audience Structure

Executive audience

  • High-level performance indicators.
  • Sales trends and target comparisons.
  • Concise charts with limited detail.

Management audience

  • Regional and product comparisons.
  • Monthly and quarterly trends.
  • Filters for further investigation.

Operational audience

  • Detailed tables and transactions where appropriate.
  • Product, customer, or order-level analysis.
  • Drill-through paths to investigate individual results.

11. Test a Multi-Page Report

Before publishing a report, test the entire user journey. Check not only the visuals on each page but also navigation, filter behavior, bookmarks, and the consistency of the report's calculations.

Testing Checklist

  • Every page has a clear and meaningful title.
  • Navigation buttons open the correct pages.
  • Shared slicers synchronize as intended.
  • Page-specific filters produce the expected results.
  • Drill-through actions open the correct destination.
  • Bookmarks restore the intended state.
  • Visuals are aligned and readable.
  • Number formats are consistent across pages.
  • Unnecessary duplicate visuals have been removed.
  • The report is tested at the intended viewing size.

12. Common Problems and Solutions

Problem Possible Cause Recommended Solution
One page contains too many visuals Different analysis topics are combined on one canvas. Separate the topics into meaningful pages.
Users cannot find a report page Page names are unclear or navigation is inconsistent. Use descriptive page names and consistent navigation.
A slicer selection does not carry across pages The slicer is not synchronized with the destination page. Review the Sync slicers pane.
Page navigation opens the wrong destination The button action references a different page. Review the button's Page navigation target.
Visuals look different across pages Formatting has not been standardized. Reuse the same formatting rules and theme.
Results differ unexpectedly between pages Different filters or slicer states affect the results. Review filter context, relationships, and synchronized selections.

13. Hands-On Practice

Task 1: Build a Four-Page Report

  1. Create Sales Overview, Sales Analysis, Product Analysis, and Regional Analysis pages.
  2. Add suitable visuals to each page.
  3. Use meaningful titles and consistent formatting.
  4. Arrange the pages in a logical order.

Task 2: Add Navigation

  1. Add a page navigation button to the overview page.
  2. Configure it to open Sales Analysis.
  3. Add suitable navigation buttons to other pages where needed.
  4. Test each destination.

Task 3: Synchronize a Year Slicer

  1. Add a Year slicer to Sales Overview.
  2. Open the Sync slicers pane.
  3. Synchronize the slicer with Sales Analysis and Product Analysis.
  4. Select a year and verify the results across the configured pages.

Task 4: Review the User Experience

  1. Check titles, alignment, spacing, and number formats.
  2. Confirm that the main purpose of each page is clear.
  3. Test navigation and filter behavior.
  4. Ask another person to explore the report and note any confusing areas.

14. Knowledge Check

Question 1: What is a multi-page Power BI report?

A. A report that contains only one chart

B. A report organized into several related report pages

C. A database with no visuals

D. A single exported image


Question 2: Why should each page have a clear purpose?

A. To organize analysis and help users find information

B. To make every page identical

C. To remove the need for titles

D. To prevent users from filtering data


Question 3: Which feature can maintain a slicer selection across configured report pages?

A. Sync slicers

B. Text formatting

C. A chart title

D. Export to PDF


Question 4: What should you check if a navigation button opens the wrong page?

A. The button's configured destination

B. Only the background color

C. The font size of the report title

D. The operating system wallpaper


Question 5: Why is consistent formatting useful across pages?

A. It makes the report easier to recognize and navigate

B. It automatically fixes all data errors

C. It removes the need for data relationships

D. It prevents report refreshes

Show Answers
  1. B — A multi-page report organizes related information across several pages.
  2. A — Clear page purposes help users locate relevant analysis.
  3. A — Sync slicers can share selections across configured pages.
  4. A — Verify the button's Page navigation target.
  5. A — Consistency improves recognition and usability.

Summary

Multi-page Power BI reports organize related business information into focused sections. Each page should answer a clear question and use visuals appropriate to its purpose, such as overview cards, trend charts, product comparisons, or detailed tables.

Use consistent titles, formatting, spacing, and navigation to make the report easy to explore. Page navigation buttons, synchronized slicers, bookmarks, and drill-through can help users move between pages while maintaining the intended context.

Before publishing, test every page, navigation action, filter combination, and important calculation. A well-structured multi-page report makes complex information easier to understand and supports more effective business decisions.