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

Visual Interactions and Edit Interactions

Visual interactions control how report visuals respond when a user selects a data point in another visual. In Power BI, selecting a category in one chart can filter, highlight, or leave other visuals unchanged. Understanding these interactions helps you create reports that are easier to explore and interpret.

Learning Objectives

  • Understand how visuals interact with one another.
  • Differentiate filtering, highlighting, and no interaction.
  • Use Edit interactions to control visual behavior.
  • Test report interactions with sample business data.
  • Identify common interaction design mistakes.

1. What Are Visual Interactions?

Visual interactions describe the response of one visual when a user selects a data point in another visual on the same report page. For example, selecting a product category in a column chart may update a sales card and a regional chart.

Report Visual Interaction Sales by Category A B C Select Category B Sales Card $24,000 Regional Sales Result Other visuals respond to the selected category

Example: Selecting Category B updates the sales card and regional sales chart when their interactions are enabled.

2. Types of Visual Interactions

Power BI provides different interaction behaviors. The available choices depend on the source visual and the target visual.

Interaction Behavior Example
Filter Restricts the target visual to data associated with the selection. Selecting a product category shows sales for that category.
Highlight Emphasizes the selected portion while retaining the remaining context when supported. A column selection highlights the related portion of a chart.
None Prevents the selected source visual from affecting that target visual. A decorative reference chart remains unchanged.
Filter Highlight None Only matching data Selection emphasized No change

These illustrations show the general idea. Actual behavior depends on the visual types and the data relationships in the report.

3. How to Use Edit Interactions

The Edit interactions feature lets you configure how one visual affects other visuals on the same report page. You can choose an appropriate interaction for each target visual.

Step-by-Step Procedure

  1. Open your report in Power BI Desktop.
  2. Go to the report page that contains the visuals.
  3. Select the visual that should control the interaction.
  4. On the ribbon, open the Format tab.
  5. Select Edit interactions.
  6. Review the interaction controls displayed on the other visuals.
  7. Choose Filter, Highlight, or None where those options are available.
  8. Test your selections and turn off Edit interactions when finished.
Power BI Desktop — Format ribbon Edit interactions Selected Visual Sales by Category Target Visual Filter Highlight None Choose behavior Test Result Select a data point and confirm that the target responds
Best Practice: Select the source visual first. The interaction settings shown on the other visuals control how those target visuals respond to the selected source.

4. Business Example: Sales Performance Report

Imagine a sales report used by a manager at CIIT TRANING INSTITUTE. The report contains a sales-by-category chart, a regional chart, and a total sales card. The goal is to help the manager analyze category performance without losing useful context.

Report Visual Suggested Interaction Reason
Sales by Category Source visual Allows users to select a category for analysis.
Total Sales Card Filter Displays the total for the selected category.
Regional Sales Chart Filter or Highlight Helps compare the selected category across regions.
Company Logo None, if it is a visual target Prevents an unnecessary interaction with a decorative element.
Sales Performance Report Sales by Category A B C Selected Category Sales $24,000 Regional Sales Manager Insight Category B selected Sales card updated Regions respond Comparison retained

Use interactions to answer business questions quickly while keeping the report easy to understand.

5. Interaction Design Guidelines

Recommended Practices

  • Use filtering when users need to focus on a specific subset of data.
  • Use highlighting when retaining the overall comparison is useful.
  • Use None for targets that should not respond to a selection.
  • Test every source visual against the relevant target visuals.
  • Keep interaction behavior consistent across related report pages.
  • Use clear titles so users understand what each visual represents.
  • Check that data model relationships support the expected results.
Important: If a target visual does not respond as expected, check its Edit interactions setting, the data model relationships, the fields used by the visuals, and any active filters or slicers. Not every visual type supports every interaction mode.

6. Common Problems and Solutions

Problem Possible Cause Suggested Solution
A chart does not change after selection. The target interaction is set to None. Enable Filter or Highlight where appropriate.
A card shows an unexpected value. Other filters or relationships affect the result. Inspect slicers, page filters, report filters, and relationships.
Users find the report confusing. Too many visuals respond in inconsistent ways. Use intentional and predictable interaction settings.
Highlighting is unavailable. The target visual does not support that behavior. Use filtering or another supported interaction.

7. Practice Exercise

Task: Configure a Sales Report

Create a report page containing these visuals:

  • Column chart: Sales by Product Category
  • Bar chart: Sales by Region
  • Card: Total Sales
  • Table: Product Details

Complete the following activities:

  1. Select the category chart and open Edit interactions.
  2. Set the Total Sales card to respond to the selected category.
  3. Choose Filter or Highlight for the regional chart based on your reporting goal.
  4. Configure the product table to show the relevant product details.
  5. Select different categories and verify each visual's response.
  6. Record which interaction settings work best for your report.

Expected outcome: Selecting a product category should update the relevant visuals according to the interaction settings you configured.

8. Knowledge Check

Question 1: What does Edit interactions control?

A. The names of report pages

B. How one visual affects other visuals

C. The location of the Power BI installation

D. The font used by the operating system

Question 2: Which interaction emphasizes a selected portion while retaining context when supported?

A. Highlight

B. None

C. Rename

D. Export

Question 3: What should you check if a target visual does not respond?

A. Only the report file name

B. Only the page background

C. Interaction settings and model relationships

D. The computer wallpaper

Show Answers
  1. B — Edit interactions controls how visuals affect other visuals.
  2. A — Highlight emphasizes the selected portion when supported.
  3. C — Check interaction settings and model relationships.

Summary

Visual interactions make Power BI reports interactive and help users explore business data. Filter narrows the data shown by a target visual, Highlight emphasizes related data when supported, and None prevents a target visual from responding to the selected source.

  • Use Edit interactions to configure how visuals respond to selections.
  • Choose interaction modes based on the report's analytical purpose.
  • Test the source visual against all relevant target visuals.
  • Check relationships and filters when interactions produce unexpected results.
  • Keep interaction behavior consistent and easy for report users to understand.