Forum Discussion
Solved
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.
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.
Or you can filter in the query to completely remove those rows from the dataset. Filters in the query editor work pretty much the same way as table filtering in Excel.
Who would know that 5 years later a newbie would find this and utter "you beautiful human being"!
