Forum Discussion

Bartosz's avatar
Bartosz
Advocate IV
10 years ago
Solved

add current selection to filter

In Excel pivot tables there ia an option to "add current selection to filter" .

Multiple values can be type, found and add to a filter list.

 

How to do this in Power BI Desktop?

In a filter field in Power BI Desktop there is a possibility to check multiple values but this list is limited. What if you have hundreds of values? I can not find there all ones I need.

In advance filtering field there is a possibility to search but maximum two values can be found.

There is an issue when I need to select lets say few brands starting from W.. or Z.. when my list of brands is bounded and last brand I see is started from K...

 

Is there any workaround?