Solved: Slicer to omit records - Page 2

DebbieE · ‎07-11-2019

I have lots of customers in my data and I want a quick way to omit customers from the report to see how this affects everything. But all the slicers seem to be about selecting a record from a list

Is there anything in Power BI where for example, I can add the Customer ID and it gets removed from the report. I dont want to do it in filters because you need to use advanced filtering and keep adding or. There might end up being hundreds of Customers that get filtered out and this would be to complex for the user

vivran22 · ‎07-12-2019

@DebbieE

you can only enable search for a text type column.
Click at the ... (3 dots) at the upper right corner of the slicer and you will find the option to enable search

You may refer to the article

Hope this should help.

Rgds,

Vivek

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

View solution in original post