Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
niveditakalele
Regular Visitor

How to allow a user to “select all” rows in a table visual?

Hi,

 

I have a matrix visual filtering based on the selected row in a table. I was wondering if there is way user can select all the rows from the table as the table also gets filtered based on the multiple slicer selection.

Overall workflow - 

Slicer selection -> filtered table results -> Selected row from table -> filters another matrix visual

 

Thanks in advance!

6 REPLIES 6
lbendlin
Super User
Super User

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Hi, thanks for your reply! I am trying to select all the rows from a table visual. I have a matrix visual which shows more info about the selected rows from table. Both matrix and the table uses different data tables. So I am looking for a way to select all from table in case user is interested in that. Thanks!

Still don't understand.  Note that "All selected"  is technically the same as "Nothing selected"  in Power BI (except for some fringe corner cases)

image.png

 

I have visuals like this in my report and I want to show the values from matrix only for the selected rows from the left table. If there are say some 5000 rows in the table and user wants to select 3000 from them, is there a way to do that selection in faster way than holding the shift + down key?

Could you possibly use a slicer rather than a table for this case? With slicers you can change the multi-select option off so users don't have to hold ctlr to select multiple rows:

Alex_Sawdo_0-1680888492708.png

 

I can't really use a slicer since there are more columns that need to be shown on table at left.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors