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

Tooltips and Report Page Tooltips

Tooltips provide additional information when users interact with a visual in Power BI. They help users explore details without placing every number, explanation, or comparison directly on the report page. Report page tooltips take this further by displaying a dedicated report page with supporting visuals and business context.

Learning Objectives

  • Understand standard tooltips in Power BI.
  • Configure tooltip fields for a visual.
  • Create a dedicated report page tooltip.
  • Connect a tooltip page to a source visual.
  • Design concise, useful tooltip content.
  • Test tooltips and troubleshoot common problems.

1. What Is a Tooltip?

A tooltip is a small information panel that appears when a user points to or interacts with a data point in a supported visual. It can show values such as revenue, profit, quantity, category, and date.

Example of a Standard Tooltip

Sales by Product Laptop Monitor Keyboard Mouse Monitor Total Sales $64,000 Total Profit $12,500 Units Sold 320 Illustrative tooltip example

The tooltip provides extra information about one product while keeping the main chart simple. Users can compare categories and inspect details without adding more labels to the chart.

2. Standard Tooltips in Power BI

Many Power BI visuals display a default tooltip when users hover over a data point. The information depends on the visual, its fields, and the current filter context.

How to Add Information to a Standard Tooltip

  1. Open the report in Power BI Desktop.
  2. Select the visual that should display additional information.
  3. Locate the visual's field configuration.
  4. Add relevant fields to the Tooltips field well, where supported.
  5. Hover over a data point and verify the displayed values.
  6. Remove unnecessary fields if the tooltip becomes crowded.
Tip: Use fields that help explain the selected data point. A sales chart may benefit from profit, order quantity, and target variance rather than several unrelated columns.

3. Understand Tooltip Context

Tooltip values are affected by the data point being inspected and by filters that apply to the visual. For example, hovering over a bar for one region may display sales for that region rather than sales for the entire company.

How Tooltip Context Works

Selected Data Point West Tooltip: West Region Region West Sales $88,000 Profit $17,000 Values shown are illustrative; actual results depend on your data model.

This behavior depends on the visual, model relationships, measures, and filters. If a tooltip displays unexpected totals, review the fields and measures used by the source visual and the tooltip.

4. What Is a Report Page Tooltip?

A report page tooltip is a dedicated Power BI report page designed to appear as a tooltip for another visual. It can contain multiple visuals, cards, charts, and explanatory text to provide richer information about a selected data point.

Standard Tooltip vs. Report Page Tooltip

Standard Tooltip Product A Sales $52,000 Profit $10,000 Quantity 260 Simple supporting values Report Page Tooltip Product A Details Sales $52K Profit $10K 260 Units Mini trend chart

Report page tooltips are useful when users need a richer explanation than a few text values. Because tooltip space is limited, keep the content focused on the selected data point.

5. Create a Report Page Tooltip

To create a report page tooltip, make a dedicated page, configure its page information and size, add supporting visuals, and assign that page to a source visual.

Step 1: Create a New Page

  1. Open your report in Power BI Desktop.
  2. Add a new report page.
  3. Rename it to something descriptive, such as Sales Tooltip.
  4. Keep the page content focused on the detail users need.

Step 2: Configure the Page as a Tooltip

  1. Select the tooltip page canvas rather than an individual visual.
  2. Open the page formatting settings.
  3. Find the canvas or page settings, depending on your Power BI Desktop version.
  4. Set the page size or type to Tooltip, where available.
  5. Enable the page's tooltip option in the page information settings.

Step 3: Add Supporting Visuals

Add a few cards or charts that explain the selected data point. For a sales tooltip, useful items may include total sales, profit, order quantity, and a small trend chart.

Best Practice: A tooltip page is usually smaller than a standard report page. Avoid adding too many visuals or long paragraphs, as users should be able to understand the information quickly.

6. Assign the Tooltip Page to a Visual

After preparing the tooltip page, configure the source visual to use it. The available controls may differ depending on the visual and Power BI Desktop version.

  1. Return to the main report page.
  2. Select the visual that should display the report page tooltip.
  3. Open the visual's formatting settings.
  4. Find the tooltip configuration.
  5. Choose the report page tooltip option, where supported.
  6. Select the page you created, such as Sales Tooltip.
  7. Hover over a relevant data point to test the tooltip.

Tooltip Configuration Flow

Create Tooltip Page Configure Page Settings Add Supporting Visuals Assign to Source Visual Test Tooltip Verify the tooltip with representative data points.

7. Design an Effective Tooltip Page

A tooltip should answer a specific question. For example, a user hovering over a region might want to see its sales, profit margin, order count, and recent trend.

Recommended Tooltip Content

  • A short title describing the selected category.
  • Two or three important KPI values.
  • A small supporting chart if it adds useful context.
  • Consistent number and date formatting.
  • Clear labels and readable text.

Tooltip Design Checklist

  • Keep the page compact and focused.
  • Use the same color conventions as the main report.
  • Avoid repeating the same information unnecessarily.
  • Ensure the tooltip makes sense for different data points.
  • Test the result in the report viewing experience used by your audience.

8. Understand Filters and Fields in Tooltips

Report page tooltips use the context passed from the source visual. The selected category, data point, and relevant filters can influence the values shown on the tooltip page.

If the tooltip should respond to a specific field, verify that the source visual contains the relevant field and that the model's relationships and measures produce the expected results.

Important: If the tooltip shows the same total for every data point when you expect different values, check the visual's fields, model relationships, filter context, and DAX measures. Do not assume the tooltip page itself is the only source of the problem.

9. Common Tooltip Problems

Problem Possible Cause What to Check
Tooltip does not appear Tooltip is disabled or not configured for the visual. Review the source visual's tooltip settings.
Report page is not available The tooltip page is not configured correctly or is not supported by that visual. Review page tooltip settings and visual support.
Tooltip shows unexpected totals Filter context or measure logic differs from expectations. Check fields, relationships, and DAX calculations.
Tooltip is difficult to read Too many visuals or small text. Simplify the layout and improve readability.
Tooltip is slow or crowded Complex content or unnecessary visuals. Reduce content and use only relevant supporting information.

10. Practical Exercise

Scenario: Product Sales Analysis

You have a Power BI report containing sales by product, region, and month. Users want more information when they hover over a product in the sales chart.

Tasks

  1. Add sales, profit, and quantity fields to a standard tooltip.
  2. Create a new report page named Product Tooltip.
  3. Configure the page as a tooltip page using the available page settings.
  4. Add cards for sales and profit.
  5. Add a small chart showing monthly sales for the selected product.
  6. Assign the tooltip page to the product sales chart.
  7. Test several products to confirm the context changes correctly.
  8. Improve the layout if the tooltip becomes crowded.

Expected Outcome

Hovering over a product should provide relevant supporting information without requiring users to leave the main report page.

11. Knowledge Check

Question 1: What is the main purpose of a tooltip?

A. To provide additional information about a data point

B. To delete a report page

C. To replace the data model

Question 2: What is a report page tooltip?

A. A dedicated report page used to show richer tooltip information

B. A database table

C. A data refresh schedule

Question 3: Where do you assign a report page tooltip?

A. In the source visual's tooltip configuration, where supported

B. Only in Windows settings

C. In the report file name

Question 4: Why is tooltip context important?

A. It helps show values relevant to the selected data point

B. It changes the computer's display resolution

C. It removes model relationships

Question 5: What makes an effective tooltip page?

A. Many unrelated charts and long paragraphs

B. Focused information, readable visuals, and relevant details

C. No labels or titles

Show Answers
  1. A — A tooltip provides supporting information for a data point.
  2. A — A report page tooltip uses a dedicated report page.
  3. A — The source visual can be configured to use the tooltip page.
  4. A — Context helps the tooltip display relevant values.
  5. B — Focused, readable content is easier to understand.

Summary

Tooltips help users explore details without overcrowding the main report. Standard tooltips display supporting values, while report page tooltips can include dedicated cards, charts, and other contextual information.

  • Add relevant fields to standard tooltips.
  • Create a dedicated page when richer tooltip content is needed.
  • Configure the page and assign it to a supported source visual.
  • Keep tooltip content concise and readable.
  • Check filters, relationships, and DAX measures if results look incorrect.
  • Test tooltips with different data points before publishing.