How to Select Multiple Rows in Power BI

Selecting multiple rows in a Power BI table or matrix should be a straightforward task, but it can be surprisingly tricky if you don't know the exact settings to use. Whether you want to highlight a few specific entries for analysis, cross-filter other visuals on your dashboard, or present an intuitive selection experience for your users, there are several ways to get the job done. This guide will walk you through the essential methods for multi-selecting rows, from simple keyboard commands to more flexible and user-friendly slicer techniques.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

The Basics: Using Keyboard and Mouse Controls

The most direct way to select multiple rows in a Power BI visual (like a Table, Matrix, or Slicer list) is with standard keyboard shortcuts. This method is ideal for quick, on-the-fly analysis directly within a report you are building or exploring.

For Selecting Specific, Non-Adjacent Rows

If you want to pick and choose individual rows that are not next to each other, the Ctrl + Click method is your go-to.

• Click on the first row you want to select.
• Hold down the Ctrl key on your keyboard.
• While holding Ctrl, click on each of the other individual rows you want to add to your selection.

As you click each row, it will be added to your highlighted group, and any other visuals on your report page will cross-filter or highlight based on this combined selection.

For Selecting a Continuous Range of Rows

If you need to select a block of rows that are all next to each other, the Shift + Click method is much faster.

• Click on the very first row in the range you want to select.
• Hold down the Shift key on your keyboard.
• While holding Shift, click on the very last row in the range.

Power BI will instantly select the first row, the last row, and every single row in between them.

Why Doesn't Ctrl+Click Always Work? A Quick Fix

A common point of frustration for Power BI users is when they try Ctrl + Click and it doesn't work as expected. Often, clicking a new row deselects the previous one. This usually comes down to a small visual-specific setting.

Here's how to check and fix it:

1. Select the table or matrix visual in your report.
2. Go to the Format visual pane (the paintbrush icon).
3. Expand the Row headers section (for matrices) or the Values section (for tables). Look for an options dropdown or similar setting that controls selection. Note: Newer versions of Power BI have simplified this, but older versions had more manual controls.
4. The key setting is now more universal. In the main Format Visual section, go to Properties &gt, Advanced options. Make sure "Multi-select with CTRL" is not disabled if the option is present. For most modern tables, this behavior is enabled by default. If it's not working, the issue is more likely related to live connections or specific visual limitations.

This simple check often resolves the issue of being unable to select multiple rows, restoring the functionality you'd normally expect.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Creating a Better User Experience with Slicers

Relying on Ctrl + Click is fine for report creators, but it's not very intuitive for end-users who may be interacting with your dashboard for the first time. A far more user-friendly method is to use a slicer. Slicers are designed for filtering and selection and make the process explicit and easy.

Step 1: Add a Slicer to Your Report

First, you'll need to add a slicer visual to your report canvas.

• Make sure no visuals are selected.
• In the Visualizations pane, click on the Slicer icon.
• A blank slicer will appear on your report page.

Step 2: Add the Field You Want to Select By

Drag the column that contains the row entries you want to select into the "Field" well of your new slicer. For instance, if you want to select rows from a sales table based on "Product Name," you would drag the "Product Name" field into the slicer.

Step 3: Configure the Slicer for Multiple Selections

This is the most important step. With the slicer selected, go to the Format visual pane.

• Click on Slicer settings to open the options.
• Under the Selection section, you'll see a key option: Allow multi-select with CTRL. By default, this is turned on, forcing users to hold Ctrl to select multiple items in the slicer list.
• Turn this option OFF. When you do, checkboxes will appear next to each item in your slicer list.

Now, users can simply check or uncheck the boxes next to each item they want to see in the table. The table visual will automatically filter to show only the rows that match the checked items. This is a much clearer and more intuitive experience than hidden keyboard shortcuts.

Inside the Slicer settings, you can also toggle the "Show 'Select all'" option on, which adds a convenient master checkbox at the top of the list for users to quickly select or deselect everything.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Understanding How Visuals Interact

Sometimes when you select an item, it doesn't filter other visuals but simply highlights them, greying out the non-selected data. This behavior is controlled by "visual interactions." Understanding this lets you define exactly what happens when a user selects rows.

Highlight vs. Filter vs. None

When you select a data point in one visual (like a slicer or a row in a table), it can affect other visuals in three ways:

• Highlight (Default): This is the default behavior. The related data is shown in full color while all other data is dimmed. It's useful for seeing the selected portion in the context of the whole.
• Filter: This is more dramatic. It completely removes all non-selected data from the other visual, as if you applied a filter from the Filters pane. Great for focusing only on what's selected.
• None: The other visuals are completely unaffected by your selection.

How to Change Visual Interactions:

1. Select the "source" visual that you'll be making selections in (e.g., your new checkbox slicer).
2. Go to the Format tab on the main Power BI ribbon at the top.
3. Click the Edit interactions button.
4. You will now see small icons appear at the top-right corner of all the other visuals on the page. These icons typically show a filter funnel, a highlight chart, and a "none" symbol (a circle with a line through it).
5. For your main data table, click the filter icon. This tells Power BI, "When I select something in this slicer, I want you to filter the data in this table, not just highlight it."
6. Click Edit interactions again to turn off editing mode.

Now, when you check multiple boxes in your slicer, the table will cleanly display only those selected rows, providing a focused and responsive experience for anyone using the report.

Advanced Method: Combining Selections with DAX

For more complex scenarios, you might need to select rows based on a condition that isn't just a simple column value. You can create a DAX measure that dynamically shows or hides rows based on a slicer selection for a more tailored solution.

Imagine you have a disconnected table for your slicer and you want to filter your main table if a product name from that selection is found within a "Notes" or "Description" field in your main table.

Step 1: Create a DAX Measure as a Filter

First, create a new measure in your primary data table. Right-click the table name in the Data pane and choose New measure. Let's call it Is Selection Visible. Here's a sample formula:

Is Selection Visible = 
// Check if the Product Name from the current row in 'SalesData' table is present in the selected values of the 'ProductSlicer' table
VAR SelectedProducts = VALUES('ProductSlicer'[Product Name])
VAR CurrentProduct = SELECTEDVALUE('SalesData'[Product Name])
RETURN
IF(
    CurrentProduct IN SelectedProducts, 
    1, 
    0
)

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 2: Apply the Measure as a Visual-Level Filter

With your main table visual selected, go to the Filters pane.

• Drag your new measure, Is Selection Visible, into the "Filters on this visual" well.
• Set the filter condition to "is 1".
• Click Apply filter.

Now your DAX measure controls the visibility of the rows. When a user selects products from the slicer, the measure returns '1' for any rows that should be visible, and the filter ensures only those rows are displayed. This technique opens up a ton of possibilities for creating sophisticated, multi-select behaviors driven by precise business logic.

Final Thoughts

Mastering how to select multiple rows in Power BI moves you from a passive data viewer to an active report builder. Using simple keyboard shortcuts like Ctrl+Click is great for quick analysis, but for published reports, user-friendly slicers with checkboxes are the way to go. Digging a little deeper into visual interaction settings ensures your entire dashboard responds exactly how you intend.

While Power BI is a great tool, all the time spent learning its layers and setting up interactions can keep you buried in the software instead of thinking about the data itself. At Graphed, we've built a platform to automate this. Instead of configuring slicers and DAX, you can simply ask for what you need in plain English - like, “Show me total sales for Product A, Product B, and Product D last month.” We'll generate an interactive chart or table instantly, letting marketing and sales teams get answers without needing to become Power BI experts first. You can always sign up for a free trial of Graphed and start getting insights in minutes.