Power BI table. Select all

[ruboo1993]

HI All,

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

Regards,

Ruben

[Vaibhavi]

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 · Accepted solution]

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

[Greg_Deckler]

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