Publish power BI report with filters

[Loeries]

I have a Power BI licence and I'm able to publish a report to a public website.  The view of is more like a dashboard, displaying 4 graphs with figures per month.  I have added a filter on the page for months, in order for the user to select a month(s) and then the graphs on the page only shows the figures for those months selected.  It works 100%.

When I publish this to the public site, it shows the graphs but not the filters.  

I did went to Options and Settings in the Power BI desktop and under Current file/Report settings, I've activated: Allow users to change filter types.

This did not work, the report on the public website still does not show the filters.  What am I missing?

[Loeries]

To embed it in my website, I select File/Embed report/Publish to web (public) and then I copy the HTML iframe code and paste it in my site

[Anand24 · Accepted solution]

Hi @Loeries ,

Filter Pane is disabled by default when you use the "Publish to Web" option for embedding. This is a limitation on "Publish to Web" option in Power BI.

You can try the below 2 alternatives:

1. Keep those filters as Slicers inside the report page

2. Try URL Filtering through string query parameters in the embed code; This would be static and user will have to edit the URL to change filters (Link)

Also, the option that you enabled(Allow users to change filter type) enables the users to change the filter type in the Power BI Services only.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Anand24]

Hi @Loeries ,

Can you attach screenshots of original page and the way it seems in website?

Also, when you say public website, how are you embedding it?

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Loeries]

The first one is copied from my workspace.  On the right, you'll see the months from the filter.

 

The following screen is when I select a month "August", it filters all graphs:

Underneath is the published graph, embeded into my website, it does not show the filters.

[Loeries]

Here is the settings when I open the file on Power BI Workspace: