Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
HI All,
How can I perform select all and deselect some rows in power BI table?
Regards,
Ruben
Solved! Go to 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
Hi @ruboo1993,
You can use the R DataTable Visual from the Visuals Gallery.
Hope you are looking for something similar.
Thanks,
Vaibhavi
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
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |