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.
Hi lukecollins,
In addition, you can also use Query Parameter to filter values dynamically. You can create a new query parameter, and specify a list of values. Then set Filter Rows condition as "less than the parameter". When you run the report, you can check different parameter values, to filter data less than different values. See:
Reference:
Deep Dive into Query Parameters and Power BI Templates
If you have any quetsion, please feel free to ask.
Best Regards,
Qiuyun Yu
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.
