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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors