Cannot filter

[Ultimacaster]

Hello all-

I'm struggling a bit with Power BI windows "disappearing" or otherwise being invisible to me; some pop-up windows are cutoff or invisible, requiring me to guess where to click to find the correct option or button, if I can even find a place to make that guess. I've included a screenshot below of a filter that I tried to work with, but because the list of values is quite long the bottom of the filter pane is extended past the bottom of the window. Consequently, it seems to be impossible to filter this way since I can't click on "OK" at the bottom of the pane. I've been able to gap the issue by using different filtering options that don't require me to find the bottom of the pane, but not all filters are friendly with these other methods. Does anyone know how to apply a filter without needing to find the bottom of the pane, or better yet, a way to keep the bottom of the pane in view?

[Anonymous · Accepted solution]

Hi @Ultimacaster,

>>Does anyone know how to apply a filter without needing to find the bottom of the pane, or better yet, a way to keep the bottom of the pane in view?

AFAIK, current query editor is impossible to keep filter stay there.

For filter items issue, you can try to apply filters, then modify formula to change filter items and range or use advanced filter mode to manually input filter items.

Regards,

Xiaoxin Sheng

[Ultimacaster]

Thanks, @Anonymous I hadn't considered trying to manually modify the formula after setting a partial filter. I think that is far more effective for what I'm trying to do than the text filter options. I started playing with the M and I think this should do the trick, I just need to remember to do my filtering in the query editor.