Power BI Visual Interaction Features: Focus Mode, Export Data, Spotlight, and Include/Exclude Records

Posted by

September 17, 2026

On March 7, 2026

Introduction

Power BI offers several built-in visual interaction features that help users analyze data more effectively and present insights with clarity. Features like Focus Mode, Show or Export Data, Spotlight, and Include/Exclude records allow you to dive deeper into visuals and inspect the underlying data. These options for visual interaction in Power BI make the visualization of the data more efficient. In this blog, we will explore these essential Power BI features and understand how they enhance data exploration and reporting efficiency. You can also read our detailed guide on the TopN function in Power BI to learn how to calculate the top-performing stores step by step.

Focus Mode

Focus Mode lets you zoom on a visual to have a closer look. You still can view and modify the filters while being in Focus Mode.

To use Focus Mode:

Before getting started, open your .pbix file in Power BI Desktop. Power BI provides several useful features that help you analyze and present your data more effectively.
Select Bar Chartvisual titled “Total Defect Qty by Material Type and Defect Type” on the Top/Bottom Analysis page.
On the upper right corner of the visual, click the icon with a diagonal arrow sign as shown below.

4. Click Back to report to go back to an unfocused view of the report.

Export Data/Show Data

Sometimes, while looking at a visual, one may feel the need to have a look at the underlying data used to create a visual. The underlying data appears in the form of a matrix with aggregated values. To explore this feature:

Select Bar Chart visual titled “Total Defect Qty by Material Type and Defect Type” on the Top/Bottom Analysis page.
On the upper right corner of the visual, click the more option icon as shown in the figure below.
From the drop-down menu, select Show as Table.

Spotlight

Spotlight features let you highlight a visual while fading the other visuals in the report, which helps when presenting your report or dashboard and drawing the audience’s attention to a specific visual.

To explore this feature:

4. Select bar Chart visual titled “Total Defect Qty by Material Type and Defect Type” on the Top/Bottom Analysis page.

5. In the upper-right corner of the visual, click the More Options icon as shown in the figure below. From the drop-down menu, select Spotlight.

Exclude/Include Records

How to use Exclude / Include (step by step)

Open Power BI Desktop.
Go to the Downtime Analysis page.
Select the line chart “Total Downtime Minutes by Material Type”.
Hover over a data point (marker) on the line that you want to exclude or include.
Right-click directly on the data point.
From the context menu, select:

Exclude→ removes that data point
Include→ keeps only that data point

The visual updates immediately.

The visual will be filtered in or filtered out depending on the option selected.

Excluded and Included filters appear under Filter > Filters on this Visual option of the Filter pane as shown below.

7. Click on the cross sign besides “excluded”to clear the filter.

Conclusion

Power BI’s visual interaction features play a crucial role in improving both analysis and presentation. Focus Mode helps users examine visuals in detail. Export and Show Data provide transparency into the underlying numbers. Spotlight draws the audience’s attention during presentations, while the Include and Exclude options enable quick visual-level filtering. When used together, these features significantly enhance the usability, clarity, and effectiveness of Power BI reports.