Filter causes report to hang

[U156531]

I'm trying to filter out the rows in a visual that have a blank in Column A. When I use the Filters on this visual window to apply a filter the report hangs indefinately as soon as I click the Apply Filter. In the filter I've tried is greater than 0 and I've tried is not blank. Both cause the report to hang. Is there another method to apply a filter to accomplish filtering out rows with a blank Column A value? 

Thanks

[U156531]

I cleared the cache and update the memory to 9000. Now I get the error there there is not enough memory to complete this operation. Is there another method to filter the data, possibly in Transform data to filter out rows with a 0 amount?

[Anonymous]

Hi @U156531 

Use Power Query to Filter Out Rows

To filter out rows with a 0 amount in a specific column before the data gets loaded into the model:

1. Open Power BI Desktop and go to Home > Transform Data. This opens the Power Query Editor.
2. Select the column you wish to filter. For instance, if you're looking to filter out rows where Column A has a 0 value.
3. Go to the Home tab, find the Filter button in the ribbon, click on it, and select Number Filters. If your column is not a number type, ensure to convert it by right-clicking the column, selecting Change Type, and then Number.
4. Choose Does Not Equal and enter . This will filter out all rows where the column value is 0.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@U156531 , Check if you have enough free memory when running the power bi desktop.

If need to increase the Data management cache