Need a quick visual filter that can be published to the Web Dashboard

[Anonymous]

I'm trying to find a way to allow my power bi web users that are accessing a dashboard to do a NOT filter easily.  Essentially I want to filter 1 customer name out of the dashboard so we can see what my metrics look like without that customer included.  I've looked at the custom visuals called "Text Filter", "Smart Filter" and tried a few other tools.  Is there a way I can create an input or button that creates a "NOT CustomerName" action?

[Greg_Deckler · Accepted solution]

Have a look at my Inverse Aggregator Quick Measure here, it was designed for this purpose:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266

[Anonymous · Accepted solution]

I was able to accomplish this in another way.  I created a conditional column, to determine if the customer name was a match or not. I set the conditions for the output to be the names of the buttons (toggles) I wanted to create. 

"CUSTOMER_Exclude_Include"

if [CUSTOMER_Account__c] = false then "CUSTOMER Only" else "Exclude CUSTOMER"

Then using the Chiclet Slicer - https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380756?tab=Overview - I was able to Add the field create from the column above into the Category setting for the slicer.  This produced a 2 button toggle that allows me to include/remove (Exclude CUSTOMER) or select only the 1 specific customer (CUSTOMER Only). 

This worked really well.  No need to deal with groups, and a very clean UI for the users. 

[Greg_Deckler · Accepted solution]

Have a look at my Inverse Aggregator Quick Measure here, it was designed for this purpose:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266