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

Bookmarks and Buttons

Bookmarks and buttons help transform a Power BI report from a collection of charts into an interactive reporting experience. Bookmarks can save selected report states, while buttons allow users to navigate between pages, change views, reset selections, and perform other configured actions.

These features are useful when building management dashboards, interactive presentations, guided reports, and reports that provide multiple views of the same business information.

Learning Objectives

  • Understand bookmarks and their purpose.
  • Create and update report bookmarks.
  • Understand bookmark options for data, display, and page state.
  • Configure buttons and their actions.
  • Build navigation buttons and view-switching experiences.
  • Use bookmarks to create report reset and guided navigation experiences.
  • Test bookmarks and buttons before publishing a report.

1. What Is a Bookmark?

A bookmark in Power BI saves a configured view of a report page. Depending on its settings, it can capture aspects such as the current page, filter and slicer selections, visibility of visuals, and other supported display states.

When a user activates the bookmark, Power BI restores the saved state covered by that bookmark's configuration. This allows report authors to create predefined views without building a separate page for every possible selection.

How a Bookmark Works

Report State Year 2026 North Sales Dashboard Bookmark Saved State Restored View Year 2026 North Configured state is restored

A bookmark can provide a quick return to a saved report view, provided the relevant state is included in its configuration.

2. Common Uses of Bookmarks

Use Case Purpose Example
Saved report views Restore a prepared selection or display state. Show the current financial year.
View switching Switch between different visual arrangements. Display a chart view or a table view.
Reset experience Return users to a predefined report state. Restore the default dashboard selections.
Guided reporting Present prepared report states in sequence. Show overview, regional results, and product details.
Show or hide content Change the visibility of supported visuals. Display an explanation panel when requested.

3. Create a Bookmark

Create bookmarks after arranging a report into the state you want to save. For example, you might select a year, choose a region, and configure the visibility of the report visuals before creating a bookmark.

Step-by-Step Instructions

  1. Open the report in Power BI Desktop.
  2. Navigate to the report page you want to save.
  3. Set the slicers and filters to the desired values.
  4. Arrange the visibility of visuals if the saved view requires it.
  5. Open the View ribbon and display the Bookmarks pane.
  6. Choose Add in the Bookmarks pane.
  7. Rename the bookmark with a meaningful name.
  8. Activate the bookmark and verify that the intended state is restored.
Tip: Use descriptive bookmark names such as Executive Overview, Regional Sales, or Default Report View. Clear names make report maintenance easier.

4. Update an Existing Bookmark

If you change the report after creating a bookmark, the saved state may no longer match your intended view. Update the bookmark after making the changes you want to preserve.

Update Workflow

  1. Navigate to the report state you want the bookmark to represent.
  2. Open the Bookmarks pane.
  3. Select the bookmark you want to update.
  4. Use the bookmark's menu and choose Update.
  5. Activate the bookmark to confirm the new saved state.
Important: Updating a bookmark can change what users see when they activate it. Check the saved filters, slicer selections, and visual visibility before updating important bookmarks.

5. Understand Bookmark Settings

Bookmark settings determine which aspects of the report state are captured. The available options depend on the Power BI interface and the type of report state being saved.

Setting Purpose When It Is Useful
Data Captures supported data-related state, such as filters and slicer selections. Saving a particular reporting selection.
Display Captures supported display state, including visual visibility. Switching between prepared report layouts.
Current page Includes the current report page in the saved state where applicable. Returning to a particular page.
Selected visuals Limits bookmark effects to selected visuals where supported. Creating view-switching behavior without changing unrelated visuals.

Bookmark State Components

Data Filter selections Slicer values Data state Display Visual visibility Layout state Display options Page Current page Navigation state Saved destination Configure the state that each bookmark should preserve.

6. Data Options and Display-Only Bookmarks

Some bookmark scenarios require data selections to be restored, while others only need the visibility of visuals to change. Understanding the difference prevents a bookmark from unexpectedly changing a user's slicer selections.

Example A: Save a Filtered View

  1. Select the required year and region.
  2. Create a bookmark that captures the intended data state.
  3. Activate the bookmark after changing the selections.
  4. Verify that the saved selections are restored.

Example B: Switch Between Two Visuals

  1. Place a chart and a table in the same report area.
  2. Use the Selection pane to control their visibility.
  3. Create a bookmark for the chart-visible state.
  4. Create another bookmark for the table-visible state.
  5. Configure the bookmarks so that changing the view does not unintentionally reset the report's filters.
Best Practice: For visual switching, carefully configure the bookmark's data and display options. A display-focused bookmark should not unexpectedly restore old slicer values.

7. What Is a Button?

A button is an interactive element that users can select to perform a configured action. Power BI supports button types and actions for navigation, bookmarks, clearing filters in supported scenarios, and other report interactions.

Button Actions

Open Details Page navigation Executive View Bookmark action Back Return navigation Every button should have a clear purpose and a tested action.

8. Create a Navigation Button

Step-by-Step Instructions

  1. Open the report page in Power BI Desktop.
  2. Insert a button using the Insert ribbon.
  3. Select the button and open its formatting options.
  4. Enable its Action setting.
  5. Choose Page navigation as the action type when available.
  6. Select the destination report page.
  7. Configure the button text, icon, size, and appearance.
  8. Test the action in the appropriate report viewing mode.
Testing Note: Depending on the environment, a button may require Ctrl+click in Power BI Desktop editing mode. In the Power BI service, interaction behavior depends on the report viewing experience. Test buttons in the environment your audience will use.

9. Use a Button to Activate a Bookmark

A bookmark button connects a user action to a saved report state. For example, a button labeled Executive Overview can activate a bookmark that displays the intended visuals and filters for an executive audience.

Configuration Steps

  1. Create the report state you want to save.
  2. Add a bookmark and give it a descriptive name.
  3. Insert a button on the report page.
  4. Enable the button's Action setting.
  5. Choose Bookmark as the action type.
  6. Select the correct bookmark.
  7. Set the button label to describe the resulting view.
  8. Test the button after changing the report's slicer selections.

10. Build a Chart and Table View Switcher

A common design is to let users switch between a chart and a detailed table without navigating to another page. Bookmarks can control which visual is visible, while buttons allow users to choose the view.

Chart and Table View Switching

Chart View Table View Sales Chart Sales Table Month Region Sales January North 4,500 February South 3,200 Bookmarks can switch visual visibility when configured correctly.

Implementation Steps

  1. Place a chart and a table in the same report area.
  2. Open the Selection pane.
  3. Set the chart visible and the table hidden.
  4. Create a Chart View bookmark configured for the intended display state.
  5. Set the chart hidden and the table visible.
  6. Create a Table View bookmark configured for the intended display state.
  7. Add two buttons and assign the corresponding bookmark actions.
  8. Test both buttons and verify that the visuals switch as expected.

11. Create a Reset View Button

A reset button can return a report to a predefined state. One approach is to create a bookmark representing the default report view and assign that bookmark to a button labeled Reset View.

Reset View Workflow

  1. Set the report to the default filters and slicer selections you want users to return to.
  2. Set the intended visual visibility and report page.
  3. Create a bookmark named Default View.
  4. Check the bookmark options so the relevant default state is saved.
  5. Add a button labeled Reset View.
  6. Assign the Default View bookmark to the button.
  7. Change several selections and test the reset button.
Important: A bookmark-based reset restores the state included in the bookmark. Verify which slicers, filters, pages, and visibility settings are captured. Do not assume it resets every possible report setting automatically.

12. Button Formatting and Accessibility

Buttons should communicate their purpose clearly. Use consistent styling, readable labels, and sufficient contrast. Avoid making users guess whether a button changes pages, changes a view, or resets a selection.

Design Element Recommendation
Label Use action-oriented text such as Open Details or Reset View.
Color Use a consistent color system for primary and secondary actions.
Size Make buttons large enough to select comfortably.
Placement Place related navigation controls together.
Accessibility Provide clear text and meaningful descriptions where supported.
Testing Verify the action in the actual report viewing environment.

13. Common Problems and Solutions

Problem Possible Cause Recommended Check
A bookmark restores unexpected selections Its data state or other options were saved differently from the intended view. Review the bookmark configuration and update it if necessary.
A button does nothing The action may be disabled or its target may not be configured. Enable Action and verify the action type and destination.
Chart and table do not switch correctly The bookmark display state or visual visibility is incorrect. Review the Selection pane and bookmark settings.
Reset button leaves some filters unchanged The bookmark does not capture the expected data state. Review which filters and slicers are included.
Bookmark names are confusing Names do not describe the saved state. Use descriptive names and remove unused bookmarks where appropriate.
Button works differently during editing Desktop editing and report viewing use different interaction behavior. Test using the appropriate interaction method and viewing mode.

14. Hands-On Practice

Task 1: Create a Regional Bookmark

  1. Select a region and reporting year in a sales report.
  2. Create a bookmark named Regional Sales.
  3. Change the slicers to other values.
  4. Activate the bookmark and verify the saved state.

Task 2: Create Navigation Buttons

  1. Create an overview page and a product detail page.
  2. Add a button to the overview page.
  3. Configure its action to navigate to Product Details.
  4. Add a suitable return-navigation button to the detail page.
  5. Test navigation between the two pages.

Task 3: Create a Chart and Table Switcher

  1. Add a chart and a table to the same report area.
  2. Use the Selection pane to configure their visibility.
  3. Create a bookmark for each view.
  4. Add Chart View and Table View buttons.
  5. Configure each button to activate the correct bookmark.
  6. Verify that the view changes without unexpectedly resetting filters.

Task 4: Create a Reset Button

  1. Save the desired default report state as a bookmark.
  2. Add a Reset View button.
  3. Assign the bookmark action.
  4. Change filters and test whether the intended default state returns.

15. Knowledge Check

Question 1: What is the purpose of a bookmark?

A. To save a configured report state

B. To permanently delete a visual

C. To create a database connection

D. To change every column to text


Question 2: Which action can a configured button perform?

A. Navigate to a report page

B. Activate a bookmark

C. Perform another supported configured action

D. All of the above


Question 3: Which bookmark option is relevant when saving filter and slicer selections?

A. Data

B. Font size

C. Border thickness

D. Page background color only


Question 4: What should you check if a button does not work?

A. Its Action setting and configured destination

B. Only the report title

C. The Windows desktop wallpaper

D. The color of every chart


Question 5: How can a reset button be implemented?

A. By assigning a default-state bookmark to a button

B. By deleting all report pages

C. By removing every relationship

D. By converting the report to a CSV file

Show Answers
  1. A — A bookmark saves a configured report state.
  2. D — A button can perform different supported actions when configured.
  3. A — The Data option controls supported data-related bookmark state.
  4. A — Verify the Action setting, action type, and destination.
  5. A — A button can activate a bookmark that represents the default state.

Summary

Bookmarks save configured report states, while buttons give users a convenient way to activate those states or perform other configured actions. Together, they help create guided, interactive, and user-friendly Power BI reports.

Use bookmarks for saved views, visual switching, and default report states. Configure buttons for page navigation, bookmark activation, and other supported actions. Review the bookmark's data and display options carefully so that filters and visual visibility behave as intended.

Always test buttons and bookmarks after changing the report. Clear labels, consistent formatting, and reliable navigation make the final report easier for users to understand and operate.