How to Cross Filter in Power BI

One of the best features of Power BI is how it makes your data reports interactive right out of the box. Clicking on one visual element can instantly change the data shown in another, turning a static report into an explorable dashboard. This guide will walk you through exactly how this core feature, called cross-filtering, works and how you can customize it to build more intuitive and powerful reports.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is Cross-Filtering and Cross-Highlighting?

In Power BI, when you select a data point in one visual, it can affect the other visuals on the report page. This interaction happens in one of two ways: cross-filtering or cross-highlighting. Understanding the difference is the first step to mastering interactive reports.

Imagine a simple sales report with two visuals:

• A bar chart showing total sales revenue by product category (e.g., 'Laptops', 'Monitors', 'Accessories').
• A map showing sales by state.

Here’s how the interactions play out:

• Cross-filtering actively removes data that doesn't apply to your selection. If you click on the 'Laptops' bar in the bar chart, the map visual will update to show sales revenue only from laptops in each state. Any states where no laptops were sold might disappear entirely from the map. The filter isolates the selection.
• Cross-highlighting keeps all the original data visible but dims everything that is not part of your selection. If you click on the 'Laptops' bar, the map would still show the total sales for all states, but the portion of those sales that came from laptops would be highlighted in a brighter color. The non-laptop sales would appear faded in the background, which is useful for seeing proportions and context.

By default, Power BI decides whether to filter or highlight based on the visual types you’re using. But the real power comes from knowing how to control these interactions yourself.

How to Use Power BI Cross-Filtering: A Step-by-Step Guide

The best part about cross-filtering is that it works automatically. You don't need to configure complex settings to get started. Let’s build a basic scenario to see it in action.

For this example, let's assume we have a simple dataset with sales information, including product names, sales amounts, dates, and store locations. We’ll build a report with three visuals:

• A pie chart showing sales by Region.
• A column chart showing sales by Month.
• A table showing specific details for each transaction.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Build Your Visuals on the Report Canvas

Drag and drop the fields you need onto the report canvas to create a few visuals. This is standard report building. For our example, arrange the pie chart, column chart, and table on the page. At this point, everything shows the total data.

Step 2: Select a Data Point to Filter By

This is where the magic happens. Simply click on a segment of one of your visuals. For instance, click the "East" region slice in the pie chart. Notice how a single click is your trigger.

Step 3: Observe the Interactive Changes

Instantly, the other visuals on your report page react to your selection. In our example:

• The Column Chart for sales by month will now only display sales data that occurred in the "East" region. The overall numbers will be lower because it's showing a filtered subset of the data.
• The Table visual will filter down to show only the individual transaction rows that belong to the "East" region.

To clear the filter, you can simply click on the same pie chart slice again, or click in the white space of that visual. All the other visuals will return to their default, unfiltered state.

This immediate feedback loop is what makes Power BI dashboards so user-friendly and great for exploring data on the fly. You can find insights that would have required building several separate-filtered reports in a tool like Excel.

How to Customize and Control Visual Interactions

Power BI’s default behavior is smart, but sometimes you need fine-grained control over how visuals interact. For example, you might have a KPI card at the top of your report showing total company revenue that you never want to be affected when a user clicks on other charts. Or, you might want to change a default cross-highlighting interaction to be a cross-filtering one instead.

Here’s how you can manually edit these interactions.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Enable the "Edit Interactions" Mode

First, select the visual that you want to be the "source" of the filter. This is the chart that your user will be clicking on. Once it's selected, navigate to the Format tab on the Ribbon at the top of the Power BI Desktop window. Click the Edit Interactions button.

Step 2: Choose the Interaction Type for Each Visual

Once you enable "Edit Interactions," you'll notice that small icons appear in the top right corner of all the other visuals on the page. These icons let you define how the source visual you selected in Step 1 will affect each of the target visuals.

You’ll see up to three options on each target visual:

• Filter: The funnel icon. Choosing this will cause the source visual to cross-filter the target visual.
• Highlight: The chart icon. This option causes the source visual to cross-highlight this one.
• None: The circle with a line through it. This disables any interaction. Clicking the source visual will have no effect on this target visual.

You have to set these controls for each source visual individually. If you want to change how your column chart filters your pie chart, you'd first select the column chart, click "Edit Interactions," and then choose the desired icon on the pie chart. When you're done, simply click the "Edit Interactions" button again to exit the mode.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

A Quick Note on Bi-Directional Cross-Filtering

Interactivity also depends on your underlying data model’s relationships. Typically, relationships have a "one-to-many" setup, like one product category containing many individual sales. By default, the filtering direction is uni-directional, meaning the "one" side (Product Category) can filter the "many" side (Sales).

However, you can enable bi-directional cross-filtering in the relationship settings. This allows the "many" side to also filter the "one" side. For example, if you selected a specific product in a large sales table, a bi-directional filter would update a product category chart to show only the category that product belongs to.

While powerful, be mindful when using this. Bi-directional relationships can sometimes create ambiguity in more complex data models and might impact report performance. It’s best to use them purposefully when you explicitly need filters to travel "uphill" in your model.

Practical Tips for Better Interactive Reports

Now that you know the mechanics, here are a few best practices to make your reports even better:

• Guide Your Audience: Don't assume your users know they can click on chart elements. Sometimes a small text box with a note like "Click on a region in the map to filter the charts below" can make your report much more accessible.
• Be Purposeful with Your Interactions: Before deciding between filtering and highlighting, ask yourself what tells a clearer story. Filtering is excellent for seeing drilled-down details. Highlighting is great for seeing a part-to-whole relationship. Set interactions deliberately for each visual.
• Use Slicers for Key Filters: While cross-filtering provides a great ad-hoc analysis experience, conventional slicers are still best for primary filters, such as date ranges or business units. It aligns with user expectations for how most dashboards function.
• Control What Doesn't Change: Use the "None" interaction setting to protect important summary numbers and KPIs. Your total sales value, number of customers, or overall conversion rate should probably remain static to provide constant context as an anchor for the user.
• Combine with Drillthroughs: Cross-filtering is just one layer of interactivity. You can pair it with drillthroughs to move from a high-level overview chart to a dedicated new page with detailed information about what you selected. For example, a user could cross-filter by a specific month, then right-click on a product category and drillthrough to another report page showing all individual transactions for that product that month.

Final Thoughts

Understanding and controlling how Power BI's visuals interact is a fundamental skill for building dynamic and user-friendly reports. Moving beyond the default settings allows you to guide the user's analytical journey, making insights easier to uncover and data stories clearer to tell.

Getting your data pipeline built, cleaned, and set up for interactivity in a tool like Power BI always takes time. At Graphed, we handle that entire process for you. Because you can use simple natural language in our dashboards, the experience feels a lot like dynamic cross-filtering - you can ask to see your data "segmented by campaign" or "just for traffic from the US," and get both the visuals and the underlying data table updated in seconds. It allows you to build completely interactive reports that bring all your marketing and sales data together without the manual setup.