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
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
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. |
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
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
- Open the report in Power BI Desktop.
- Select the visual that will act as the source of the interaction.
- Open the Format ribbon.
- Choose Edit interactions.
- Review the interaction controls displayed on the other visuals.
- Select the appropriate filter, highlight, or no-interaction option where available.
- Repeat for other target visuals if necessary.
- Exit Edit interactions and test the report selections.
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
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. |
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.
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
- Create a Sales by Category chart.
- Create a Monthly Sales chart.
- Add a Total Sales card and a product detail table.
- Use Edit interactions to configure the category chart's effect on the other visuals.
- Use filtering for the product table if only the selected category should appear.
- 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.
- Decide whether the Total Sales card should respond to the category selection.
- 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
- Create a chart showing sales by product category.
- Create another chart showing sales by month.
- Select one category in the first chart.
- Observe whether the monthly chart displays only related sales.
- Clear the selection and compare the results.
Task 2: Test Cross Highlighting
- Use a visual combination that supports highlighting.
- Select a category in the source chart.
- Observe how the target chart represents the selected contribution.
- Compare the highlighted contribution with the overall total.
Task 3: Configure Edit Interactions
- Select the source chart.
- Open Format and choose Edit interactions.
- Configure the product table to filter when supported.
- Set an appropriate interaction for the monthly chart.
- Disable the interaction for a visual that should remain unaffected, where available.
- 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
- B — Cross filtering restricts results to related data.
- A — Cross highlighting emphasizes a selected contribution while retaining context where supported.
- A — Edit interactions configures visual interactions.
- A — None prevents the source visual from affecting the target visual.
- 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.