Forum Discussion
Removing rows in Power Bi
I have a very large table in Power BI and one of the columns is labelled time spent. I would like any row where this value is less than one to be deleted/remove. Please help
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.
8 Replies
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.
Who would know that 5 years later a newbie would find this and utter "you beautiful human being"!
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 YuI would also like to know the same.
Is there any ease way to filter on cloumn and delete rows in PowerBI?
