Skip to main content

Power BI

New

Hide or show the filter fly-out panel on embedded reports with an API switch or URL parameter

Vote (67) Share
Artie Roggeband's profile image

Artie Roggeband on 17 Feb 2016 04:39:06

When a filter is added to the I-Frame url when embedding a report, this field value is dynamically added to the filter panel.
An obvious use of a URL filter field is to constrain the dataset on a per user basis and when the field is visible in the filter panel , then this constraint can be removed or changed.
if this can't be avoided for the filter to work on the dataset, then we need to be able to hide the filter panel.
We need an API parameter or URL switch to turn the filter panel on or off but keeping the filter field in the URL

Comments (7)
Artie Roggeband's profile image Profile Picture

ce93556f d739-439d-bb85-4596d51ce06d on 06 Jul 2020 00:05:45

RE: Hide or show the filter fly-out panel on embedded reports with an API switch or URL parameter

Yes, I need this feature too. I need to let the filter panel visible, so the user can use the filters I specify, but in my case the user MUST NOT SEE the filter set in the URL Parameter filter. To workaround this, I cannot use the filter panel, so I need to hide it and then add slicers visualizations to work as filters.

Artie Roggeband's profile image Profile Picture

d1784fae 854d-41f0-9582-c6f10861781a on 05 Jul 2020 22:56:36

RE: Hide or show the filter fly-out panel on embedded reports with an API switch or URL parameter

This is the exact functionality we are looking for. Right now it seems impossible to show a report in Internet Explorer/Chrome 100% full screen when you're not embedding, due to the filter panel. An URL parameter for example would be VERY usefull and give the report a much more professional look.

Artie Roggeband's profile image Profile Picture

d51bfa42 be6b-43b2-b25e-d0dac23b5697 on 05 Jul 2020 22:32:09

RE: Hide or show the filter fly-out panel on embedded reports with an API switch or URL parameter

Please can we get this sorted out?!

Artie Roggeband's profile image Profile Picture

7fa7090b adae-4e81-b35d-c64539b46d64 on 05 Jul 2020 22:26:19

RE: Hide or show the filter fly-out panel on embedded reports with an API switch or URL parameter

Incase you are using powerbi.js with your app, open it and set filterPaneEnabled to false.

Search for the snippet below:
Embed.defaultOptions = {
//filterPaneEnabled: true
filterPaneEnabled: false
};

This works for me perfectly.

Artie Roggeband's profile image Profile Picture

893aefb4 7fed-4dc5-83c3-a875e648e322 on 05 Jul 2020 22:21:50

RE: Hide or show the filter fly-out panel on embedded reports with an API switch or URL parameter

I have this exact requirement.

At present Power BI Embedded does not appear to properly support multi-tenant Saas applications. Two parameters / filters that no user should be allowed to change on the UI are TenantId and UserId and right now there is no wat to prevent this.

Artie Roggeband's profile image Profile Picture

15bcecd9 ea5a-400d-b6eb-f049820800b1 on 05 Jul 2020 22:16:29

RE: Hide or show the filter fly-out panel on embedded reports with an API switch or URL parameter

X-Linking to a similar idea:
Hide filters for shared Reports or prevent user from changing filters.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10319553-hide-filters-for-shared-reports-or-prevent-user-fr

Artie Roggeband's profile image Profile Picture

15bcecd9 ea5a-400d-b6eb-f049820800b1 on 05 Jul 2020 22:16:29

RE: Hide or show the filter fly-out panel on embedded reports with an API switch or URL parameter

short url from tweet: https://t.co/YMeTzZsuWd