cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TomCarpenter
Microsoft
Microsoft

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 might want a filter that allows me to exclude USA-East from the report, but I don't want the reverse to be possible (e.g., to click and view only USA-East). I want to be able to exclude them, but I don't want people to be able focus on them or display only them.

1 ACCEPTED SOLUTION

@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/

 

 

View solution in original post

3 REPLIES 3
VahidDM
Super User
Super User

Hi @TomCarpenter 

 

You can set that filter on the Filter Pane and hide the filter pane before publish, then users can not change that.

The other solution is, to set thet filter in Power Query if you don't want to include USA-East in your report.

 

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/

 

 

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.

@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/

 

 

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors