Forum Discussion

TomCarpenter's avatar
TomCarpenter
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
Solved

Page level "exclude" filter

Is it possible to create a filter that allows me to exclude a group (but not display the opposite) from a report page? For example, imagine that I have three groups USA-West, USA-East, USA-Mid. I ...
Need Help
TomCarpenter's avatar
TomCarpenter
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Thanks! Is there any way to let the user toggle "Exclude USA-East" on/off? I am essentially wanting a filter where USA-East can be excluded but it is impossible to exclude any other category. In a standard filter, the user can select any combination regions to exclude. I want to make sure that USA-West could never be deselected, while USA-East can be toggled on and off. 

I suppose I could create an alternate page where the filter is locked and hidden (essentially a duplicate page with USA-East filtered out) but I'd love to avoid that.

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

TomCarpenter 

 

Yes, you can set Bookmark with Toggle to include or exclude the  USA-East:

https://www.youtube.com/watch?v=_Afcj8mT5_Q

 

or use this custom visual:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200002754?tab=overview

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/