cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akkapolki
New Member

How to hide "Report level filters" for some field on web?

I created page and added "Report level filters" for field: FirstName and hided it by setting "Hide in report view" as picture:

1.png

 

After publishing to web, the "Report level filters" for field: FirstName is not hide as picture:

How to hide it? Is it possible?

2.png

1 ACCEPTED SOLUTION

@akkapolki You are using the column as a Report Level filter, so it will always show up in the filters. There is no way currently to hide filters.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

8 REPLIES 8
descon
Regular Visitor

If the report filter should not be visible, one way to do this is to push the filter down to the query. For example, if I wish to only display data for which Country=Canada, I can add this in the query. It will be added as a 'Filtered Rows' step.

@akkapolki You are using the column as a Report Level filter, so it will always show up in the filters. There is no way currently to hide filters.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Thanks for the response - any idea if this is a planned feature? Seems trivial yet powerful.

Possible turn around:
- Create a new page
- add the filters and synchronize them with all the pages of the report
- hide this page

This way we can hide the Slicers but if we apply a filter using a column it starts appearing in the filters on the right hand side and user can see all the other values. Is there a better solution to hide the filters from the user?

Thanks for this tip. How do I synchronize teh filters for the different pages?

Open "View" tab on top, select box with "Sync slicers", choose the filter You want to synchronize and mark only filter column (with funnel), leaving "eye" unmarked.

@Seth_C_Bauer Thank you.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors