How can I perform select all and deselect some rows in power BI table?
Go to Solution.
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.
View solution in original post
You can use the R DataTable Visual from the Visuals Gallery.
Hope you are looking for something similar.
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")
Proud to be a Super User!
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.