cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DebbieE Senior Member
Senior Member

Slicer to omit records

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

1 ACCEPTED SOLUTION

Accepted Solutions
vivran22 Member
Member

Re: Slicer to omit records

@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

16 REPLIES 16
vivran22 Member
Member

Re: Slicer to omit records

Hi,

Is there a way to share the sample data and the desired output? The requirement is not very clear from the description above.

Rgds,
Vivek
Highlighted
DebbieE Senior Member
Senior Member

Re: Slicer to omit records

SlivertoOmitRecords.JPG

These slicers, if you select a Postcode that means only that Postcode is shown. I want to select a Postcode (Or many Postcodes and remove them from the visual. 

tex628 New Contributor
New Contributor

Re: Slicer to omit records

Toggle the select all on the slicer and have every option selected from the beginning. This will make it so that the slicer will remove anything you select.

Your other option is to build a negative filter, that litterally works the opposite way by removing everything that you select, but thats quite the messy process if i remember correctly.

 image.pngimage.png

DebbieE Senior Member
Senior Member

Re: Slicer to omit records

I cant see an option to have everything selected from the start in the slicer. I dont really want the use to have to turn on select everything before they start. Am I missing an option to select everything in the slicer rather than having to switch it on

 

It seems like this could be an idea for a new slicer visual? For my logic, the business is looking at Outliers. If they have looked into an outlier and are happy that they have come to a conclusion they simply want to omit as they go

 

tex628 New Contributor
New Contributor

Re: Slicer to omit records

I totally agree with you that regarding the requirement for a new slicer. The select all option is located under the selection controls options for the slicer. Once you have enabled it you select all on that specific slicer, save the report and then that should mean that any user that opens the report will have all options selected from the beginning. 

The only issue that i can think of is that i dont know how it handles new records. For example when you get new customers, will they also be selected by default? 

vivran22 Member
Member

Re: Slicer to omit records

@tex628 @DebbieE 

 

If you will save the report with "Select All" option and if any new option/item will be added to the list, then it will be selected by default. And in case if you have unchecked certain items from the slicer and then save the report, they will remain unchecked untill the selection has been reversed.

 

Hope this helps.

 

Rgds,

Vivek

 

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

DebbieE Senior Member
Senior Member

Re: Slicer to omit records

I do have a problem with the solution.

 

I have thousands and thousands of attributes to go through. The user should be able to simply type in the ones they want to omit. Not scroll through because there are too many to scroll through. So this solution doesnt work in this situation. Its only good for a smaller number of records

vivran22 Member
Member

Re: Slicer to omit records

@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

DebbieE Senior Member
Senior Member

Re: Slicer to omit records

Done,

 

My only concern now is that the Slicer is in a slicer bookmark.

 

in the pbix file in Desktop Ive set it to all with everything selected. Added a search at the top and saved. Im concerned that the user will go in. remove the Properties they want removing and go back to the filter and it will reset with the settings from my pbix file.

 

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 290 members 2,900 guests
Please welcome our newest community members: