22.10 Edit Interactions: Filter, Highlight, None

By Ravindra Bagale Last updated: 6 October 2026

Start with a problem

When Rani clicks Pune on the City chart, the Category chart only highlights instead of filtering; she wants exact Pune values.

Explain simply

Edit interactions decides how a selection in one visual affects others: Filter (removes other data), Highlight (dims the rest), or None (no effect).

Show the data

Category	All cities (₹)	Pune (₹)
Dairy	1,050	400
Fruits	400	250
Snacks	650	200

About this data: This table uses columns: Category, All cities (₹), Pune (₹). This table uses columns: Interaction, Category chart after clicking Pune. This table uses columns: Visual, Shows. This table uses columns: Visual, Interaction, Shows. Values shown are the lesson examples already on this page (not a new dataset).

Fictional sample data. Practice file: visuals_orders_apr_may_2026.csv (source: src/practice/).

Demonstrate

Select the City chart.
Format › Edit interactions.
On the Category chart, click the Filter icon (funnel).
Click Pune; then try Highlight and None.

Show the result

Filter, highlight and none interactions, sample layout with fictional data

Your result should look like this (fictional sample):

Interaction	Category chart after clicking Pune
Filter	Dairy 400, Fruits 250, Snacks 200
Highlight	Full bars 1,050 / 400 / 650 with Pune part dark
None	1,050 / 400 / 650 unchanged

Explain what happened

Filter re-evaluates with City = Pune. Highlight shows both the total and the Pune share. None ignores the selection.

Explore further

Set None on a total card if it should never change.

Detailed reference for this lesson:

Edit interactions in Power BI with example — in 30 seconds

What: Edit interactions decides what happens to other visuals when you click one: Filter, Highlight or None.

Why: The State Total card must stay ₹2,600 even when someone clicks Pune on the bar chart.

Tiny example: Click Pune on the chart. The Total Sales card filters to ₹1,200. The State Total card (set to None) stays ₹2,600.

First look at the data (before → after):

Edit interactions in Power BI with example: before and after tables, fictional Blinkit Maharashtra data

Same before / after tables as text

Before — Click Pune on the city bar chart — default behaviour

Visual	Shows
City bar chart	Pune highlighted
Card: Total Sales	₹1,200
Card: State Total	₹1,200 (wrong for this card)

Formula / click path

Select the bar chart › Format › Edit interactions
On the State Total card, click the None icon (circle with a line)

After — After Edit interactions (Pune clicked)

Visual	Interaction	Shows
Card: Total Sales	Filter	₹1,200
Card: State Total	None	₹2,600
Column chart by month	Highlight	Pune part dark, the rest light

Do it step by step:

Click the city bar chart, the visual people will click.
Click Format › Edit interactions in the ribbon.
Small icons appear on every other visual.
On State Total, click None.
On the month chart, keep Highlight or click Filter.
Click Edit interactions again to switch it off. Test by clicking Pune.

Simple bhashet sangaycha tar, by default, clicking a data point in one visual cross-highlights or cross-filters other visuals on the page. Slicers filter them.

Steps in Power BI

Select the source visual (e.g. the Platform slicer or the "Orders by City" bar chart).
Format › Edit interactions (the Format tab appears on the ribbon when a visual is selected).
Small icons appear on every other visual. Choose one per visual: Filter (funnel: show only the selected data), Highlight (keep the total, highlight the selected part; available on some visuals), or None (ignore the selection).
Example: set the "Total Orders – all platforms" card to None for the Platform slicer, so it always shows the total.
Click Edit interactions again to finish.
Report-wide default: File › Options and settings › Options › Current File › Report settings › Change default visual interaction from cross highlighting to cross filtering.

Ravindra Bagale's Tip

Friends, many students accept the default cross-highlighting everywhere, so clicking a small chart makes the whole page flash. Use Format › Edit interactions to set Filter, Highlight or None deliberately, especially for KPI cards that should always show the full total. Never forget this.

Fix common mistakes

Wrong result	Reason	Correction
Card unchanged after click	Interaction None	Set Filter
Users confused by faded bars	Highlight default	Use Filter for exact values
Interaction edited on wrong pair	Selected the target first	Select the source visual first

Practise independently

Practice task

With Filter, click Nashik. What does the Category chart show?

Hints

Nashik: 303 Dairy 300, 304 Fruits 150, 307 Dairy 350.

Solution

Dairy 650, Fruits 150, Snacks blank.

Think like a professional

Interaction settings are part of report logic. Agree defaults (filter vs highlight) with users.

Ravi Sir's Cards for this lesson

Edit interactions: filter, highlight, none. Some visuals should not change when users click another visual.

Revision card How do you stop a card from changing when users click a chart? Use Edit interactions. Select the chart, open Format > Edit interactions, and choose None on the card.

How do you stop a card from changing when users click a chart? Use Edit interactions. Select the chart, open Format > Edit interactions, and choose None on the card.

Interview card Filter vs highlight interaction. Both are ways a selected visual changes other visuals.

Comparison card

मराठी cards