cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ruboo1993 Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Community Support Team
Community Support Team

Re: Power BI table. Select all

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

3 REPLIES 3
Super User
Super User

Re: Power BI table. Select all

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")

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

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Power BI table. Select all

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

Vaibhavi Frequent Visitor
Frequent Visitor

Re: Power BI table. Select all

Hi @ruboo1993,

 

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

 

R DataTable

 

Hope you are looking for something similar.

 

Thanks,

Vaibhavi