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

Cross Filtering and Highlighting

Power BI reports allow users to interact with charts, tables, and other visuals. When a user selects a data point in one visual, other visuals on the report page can respond by filtering their data or highlighting the related portion of their existing data.

Cross filtering and cross highlighting help users explore relationships between business metrics without creating a separate report for every question. For example, selecting a product category can help a manager examine its sales by month, region, and product.

Learning Objectives

  • Understand cross filtering and cross highlighting.
  • Learn how visual selections affect other report visuals.
  • Configure visual interactions using Edit interactions.
  • Understand when to use filtering, highlighting, or no interaction.
  • Test interactive behavior in a report.
  • Troubleshoot common interaction problems.

1. What Is Cross Filtering?

Cross filtering occurs when selecting a data point in one visual limits the data displayed in another visual to the related records. The second visual recalculates or redraws its results based on the selection.

Suppose a report contains a chart showing sales by category and another chart showing sales by month. Selecting the Electronics category can cause the monthly chart to display only the monthly sales associated with Electronics.

Cross-Filtering Example

Sales by Category Electronics Furniture Clothing Other Select Monthly Sales Electronics only Jan Feb Mar Apr May

The selected category limits the monthly chart to related sales. The exact results depend on the data model, relationships, and interaction settings.

2. What Is Cross Highlighting?

Cross highlighting emphasizes the portion of another visual that corresponds to a selected data point. Instead of removing all unrelated data, the visual can retain the overall context and distinguish the selected contribution from the remaining values.

For example, a chart may display total sales by month. Selecting Electronics in another chart can highlight the Electronics contribution within each month's total while leaving the full monthly totals visible.

Cross-Highlighting Example

Monthly Sales by Category Selected category Remaining sales Jan Feb Mar Apr May

The highlighted portion represents the selected contribution, while the remaining portion preserves context. The exact rendering varies by visual type and supported interaction behavior.

3. Cross Filtering vs. Cross Highlighting

Feature Cross Filtering Cross Highlighting
Main behavior Restricts results to related data. Emphasizes related data while retaining broader context.
Unrelated values May be excluded from the affected visual's results. May remain visible as the unselected portion.
Best use Investigating only the selected group. Comparing a selected contribution with the total.
Example Show monthly sales only for Electronics. Show Electronics sales as a portion of total monthly sales.
Remember: Filtering focuses on the selected subset. Highlighting helps preserve context and show the selected subset's contribution. The available behavior depends on the visual combination.

4. How Visual Interactions Work

Power BI visuals can interact when a user selects a bar, segment, category, or other data point. The affected visual uses the selection context and the data model to determine which information to display.

Interaction Flow

1. Select Choose a data point in a chart 2. Evaluate Relationships and interaction settings 3. Update Filter, highlight, or do nothing The behavior depends on model relationships and visual settings.

5. Configure Edit Interactions

Edit interactions lets a report author decide how one visual affects other visuals on the same report page. This is useful when a visual should filter another chart, highlight a contribution, or remain unaffected by a selection.

Step-by-Step Instructions

  1. Open the report in Power BI Desktop.
  2. Select the visual that will act as the source of the interaction.
  3. Open the Format ribbon.
  4. Choose Edit interactions.
  5. Review the interaction controls displayed on the other visuals.
  6. Select the appropriate filter, highlight, or no-interaction option where available.
  7. Repeat for other target visuals if necessary.
  8. Exit Edit interactions and test the report selections.
Important: Select the source visual first. Edit interactions configures how that visual affects the other visuals. Selecting a different source visual may show different interaction controls.

6. Filter, Highlight, and No Interaction

The interaction choices determine how target visuals respond to the selected source visual. The exact options depend on the target visual and the interaction being configured.

Interaction Result Example
Filter Restricts the target visual to the relevant data. A category selection filters a product table.
Highlight Emphasizes the selected contribution where supported. A category selection highlights its share of monthly sales.
None Prevents the selected source visual from affecting the target visual. A company logo or fixed reference visual remains unchanged.

Choosing an Interaction

Filter Only selected data Highlight Selected share emphasized None Unaffected visual No response

7. Cross Filtering with Tables and Cards

Cross filtering is not limited to charts. A selection in one visual may also affect tables, matrices, and cards when the visual types, model relationships, and interaction settings support the behavior.

Example: Sales Dashboard

Visual Purpose Possible Interaction
Sales by Category chart Select a category. Acts as the source visual.
Product table Show products related to the selection. Filter to the selected category.
Total Sales card Display the selected data's total. Recalculate based on the selection if connected.
Monthly sales chart Explore the selected category over time. Filter or highlight, depending on configuration.
Design Tip: Make sure the behavior of important cards is clear. If a card should always show an overall total, configure and test its interaction rather than assuming it will remain unchanged.

8. Understand the Role of Data Relationships

Visual interactions depend on more than the chart settings. The data model determines how selections can propagate between fields and tables. If two visuals use fields from tables that are not connected as expected, the result may differ from the intended behavior.

What to Check

  • Confirm that the source and target fields come from the intended tables.
  • Review relationships between dimension and fact tables.
  • Check relationship direction and whether relationships are active.
  • Verify that the target visual uses data affected by the selected field.
  • Review Edit interactions to confirm the intended response.
Modeling Note: Avoid changing relationship directions just to force a visual interaction. Review the model design first and make changes only when they are correct for the data.

9. Practical Business Scenario

A sales manager at CIIT TRANING INSTITUTE reviews a report containing product categories, monthly sales, regions, and total revenue. The manager wants to compare categories without losing the context of the overall monthly trend.

Recommended Configuration

  1. Create a Sales by Category chart.
  2. Create a Monthly Sales chart.
  3. Add a Total Sales card and a product detail table.
  4. Use Edit interactions to configure the category chart's effect on the other visuals.
  5. Use filtering for the product table if only the selected category should appear.
  6. Use highlighting on the monthly chart if you want to show the category's contribution while retaining the broader totals and the visual supports it.
  7. Decide whether the Total Sales card should respond to the category selection.
  8. Test each interaction before sharing the report.

10. Common Problems and Solutions

Problem Possible Cause Recommended Check
A visual does not respond Its interaction may be disabled or the model may not support the expected filtering. Review Edit interactions and model relationships.
A chart shows filtered results instead of highlighting The configured interaction is filtering, or the visual combination does not support highlighting. Review the available interaction choices.
A card changes unexpectedly The card responds to the source selection. Check whether its interaction should be enabled or disabled.
A selection produces unexpected values The fields, relationships, or measures may not represent the intended data context. Validate the model and measure results.
Some visual pairs have fewer options Interaction behavior depends on the visual types and configuration. Use the options available for that specific target visual.

11. Hands-On Practice

Task 1: Test Cross Filtering

  1. Create a chart showing sales by product category.
  2. Create another chart showing sales by month.
  3. Select one category in the first chart.
  4. Observe whether the monthly chart displays only related sales.
  5. Clear the selection and compare the results.

Task 2: Test Cross Highlighting

  1. Use a visual combination that supports highlighting.
  2. Select a category in the source chart.
  3. Observe how the target chart represents the selected contribution.
  4. Compare the highlighted contribution with the overall total.

Task 3: Configure Edit Interactions

  1. Select the source chart.
  2. Open Format and choose Edit interactions.
  3. Configure the product table to filter when supported.
  4. Set an appropriate interaction for the monthly chart.
  5. Disable the interaction for a visual that should remain unaffected, where available.
  6. Test every configuration.

12. Knowledge Check

Question 1: What is cross filtering?

A. Removing a table from the model

B. Restricting a target visual to data related to a selection

C. Changing a column's data type

D. Publishing a report


Question 2: What is cross highlighting intended to do?

A. Emphasize the selected contribution while retaining context where supported

B. Delete unrelated report pages

C. Replace every visual with a table

D. Refresh all data sources


Question 3: Which Power BI feature configures how a visual affects other visuals?

A. Edit interactions

B. Power Query parameters only

C. Manage relationships only

D. Export data


Question 4: What does the None interaction do?

A. Prevents the source visual from affecting the target visual

B. Deletes the source visual

C. Removes all data from the report

D. Converts the target visual into a slicer


Question 5: Why should data relationships be checked?

A. They influence how filter context propagates through the model

B. They determine the font size of all titles

C. They automatically create every visual

D. They remove the need for testing

Show Answers
  1. B — Cross filtering restricts results to related data.
  2. A — Cross highlighting emphasizes a selected contribution while retaining context where supported.
  3. A — Edit interactions configures visual interactions.
  4. A — None prevents the source visual from affecting the target visual.
  5. A — Relationships influence how filter context propagates.

Summary

Cross filtering and cross highlighting make Power BI reports interactive by allowing selections in one visual to affect other visuals on the same report page.

Cross filtering restricts a target visual to related data, while cross highlighting emphasizes the selected contribution and can preserve the broader context. The available behavior depends on the visual types, model relationships, and interaction settings.

Use Edit interactions to configure filtering, highlighting, or no interaction where supported. Test the report with realistic selections to confirm that charts, cards, and tables respond as intended.