Forum Discussion
Removing rows in Power Bi
Try using the time spent as a filter for the page. Drag it to page level filter, swith to advanced filtering, select "is greater than", and choose your amount.
Can also be used as a visual level filter.
What if I want to delete rows in order to manage the size of my data set? Will filtering accomplish that?
I would also like to know the same.
Is there any ease way to filter on cloumn and delete rows in PowerBI?
If you want to manage the size of the actual data set, you need to do your filtering in the query editor. This means it will be filtered before loading, so nothing that you have filtered out will be available to use anywhere. If you want all the data to be available in the dataset but not shown in a particular report or visual, you can add filters at the report or filter level through the filter panel on the right side of the report editor.
Could you let me know , how to do the filtering in the query editor for any particular rows.
