cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ruboo1993
New Member

Power BI table. Select all

HI All,

 

How can I perform select all and deselect some rows in power BI table?

 

Regards,

Ruben

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @ruboo1993

If you mean to perform this on report, you could add these columns in a table visual, then add the column which you use to select or deselect rows in a slicer.

 

To select all, please go to "format"->selection controls, turn on "select all" bar.

 

To deselect some rows, please go to "format"->selection controls, turn off "single select" bar.

then you could select some rows, this means some rows are deselected.

or you could select all, then uncheck some values, these rows would be deselected.

 

If you want to select and deselect some rows in power query to change the dataset model, you could consider the function:

Table.SelectRows(table as table, condition as function)

It will return a table containing only the rows that match a condition

 

If you want to filter some rows to get a new table, you could take Greg_Deckler's advide into consideration.

 

Best Regards

Maggie

View solution in original post

3 REPLIES 3
Vaibhavi
Frequent Visitor

Hi @ruboo1993,

 

You can use the R DataTable Visual from the Visuals Gallery.

 

R DataTable

 

Hope you are looking for something similar.

 

Thanks,

Vaibhavi

 

v-juanli-msft
Community Support
Community Support

Hi @ruboo1993

If you mean to perform this on report, you could add these columns in a table visual, then add the column which you use to select or deselect rows in a slicer.

 

To select all, please go to "format"->selection controls, turn on "select all" bar.

 

To deselect some rows, please go to "format"->selection controls, turn off "single select" bar.

then you could select some rows, this means some rows are deselected.

or you could select all, then uncheck some values, these rows would be deselected.

 

If you want to select and deselect some rows in power query to change the dataset model, you could consider the function:

Table.SelectRows(table as table, condition as function)

It will return a table containing only the rows that match a condition

 

If you want to filter some rows to get a new table, you could take Greg_Deckler's advide into consideration.

 

Best Regards

Maggie

View solution in original post

Greg_Deckler
Super User IV
Super User IV

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

That being said:

 

Table = FILTER(ALL('Table1'),[Column]="Some value")

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors