Reply
Highlighted
Frequent Visitor
Posts: 14
Registered: ‎10-30-2018
Accepted Solution

Visual level filter is ignored on Power BI Service

Hi,

 

I have an issue with Visual level filter. In Desktop I have added a Visual level filter to one of my charts (Show items when the value is less than 16). But on the Power BI Service the same filter is ignored. I can see that this filter has been added but it is filtered as All, it just ignores what I've selected on the Desktop.

 

Any ideas why this is happening?

 

Thanks in advance!

 

Br,
Edgars

 


Accepted Solutions
Frequent Visitor
Posts: 14
Registered: ‎10-30-2018

Re: Visual level filter is ignored on Power BI Service

Hi,

 

It looks like I've found what was the problem. I have created selection of bookmarks. And when I created a bookmark for this particular page with this visual, I hadn't had the filter applied yet. So I applied the filter one more time how I want the visual to be and then created a bookmark. Now for all report viewers the filter is applied when they press on bookmark button.

 

I'm still quite new in Power BI so I didn't know that filters affect also the bookmarks.

 

Thank you for the help anyway!

 

Br,

Edgars

View solution in original post


All Replies
Community Support Team
Posts: 1,882
Registered: ‎07-10-2018

Re: Visual level filter is ignored on Power BI Service

Hi @EdgarsCK,

 

Based on my test, I cannot reproduce your issue here by using the Power BI desktop version 2.65.5313.841 64-bit (December 2018). Did you apply filter after editing the visual level filter?

2.PNG

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Posts: 2,925
Registered: ‎06-24-2015

Re: Visual level filter is ignored on Power BI Service

It should apply the same setting on the filter.

When you re-upload the PBIX does it prompt you to replace existing dataset?
Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Frequent Visitor
Posts: 14
Registered: ‎10-30-2018

Re: Visual level filter is ignored on Power BI Service

Hi @v-frfei-msft,

 

I have a version 2.65.5313.621 64-bit (December 2018) and yes, I applied the filter after editing the visual level filter - pressed enter and the Apply filter button became grey/unactive. See screenshots below how it is for me. First is what I see on the Desktop and the second one what I see on the Service. Filter - Top 10 Case Categories.

Desktop.JPGDesktopService.JPGService

Br,
Edgars

Frequent Visitor
Posts: 14
Registered: ‎10-30-2018

Re: Visual level filter is ignored on Power BI Service

Hi @GilbertQ,

 

Yes, it prompts with a question if I want to replace the existing dataset with this one. I press Replace, the new data is there but this particular filter is not saved. This has happened to some other visuals as well in this report but I managed to find workarounds for those but not for this one yet.. I assume I'll have to write some kind DAX formula that will give me only top 15 values instead of using the filter.

 

Br,

Edgars

Frequent Visitor
Posts: 14
Registered: ‎10-30-2018

Re: Visual level filter is ignored on Power BI Service

[ Edited ]

@v-frfei-msft & @GilbertQ

 

 

What I've noticed is that every time I'm publishing a new version of the report, field "Reset to default" becomes active and yellow. When I press it then everything is correct because then report shows author's default view of the report.

Solution.JPG

 

It is the same for other report viewers. They have to press this button every time they enter this report to "activate" that particular filter.

 

In addition to the fact that filter is being ignored, sometimes the sorting is also ignored on that visual. In the web it sometimes is sorted by the name instead of the amount.

 

Br,
Edgars

Super User
Posts: 2,925
Registered: ‎06-24-2015

Re: Visual level filter is ignored on Power BI Service

Hi there

Yes that is currently by design so that every person can have their own view.

When a person first views the report they will have the author's default state.

You can also change this setting if you do not want it to be applied in your PBIX under options then put in the tick under Persistent Filters


image.png

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Frequent Visitor
Posts: 14
Registered: ‎10-30-2018

Re: Visual level filter is ignored on Power BI Service

Hi,

 

Sounds like this could solve the problem so that the end users only see the original filters (the ones that have been saved and published from the Desktop). I checked/marked this field but it didn't help for some report's end users. They still see this visual without that filter and the sorting is also not the same as in the Desktop - in Desktop the sorting is based on amount, but on the Service the sorting is displayed based on the name for that end user. See the screenshot below. Reset to default button is not active anymore (it says that report owner has disabled this option or something). And again that filter is ignored.

 111.JPG

Super User
Posts: 2,925
Registered: ‎06-24-2015

Re: Visual level filter is ignored on Power BI Service

Hi there

 

Could you also look and confirm if this setting is the same in the Power BI Service on the report settings?

 

image.png

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Frequent Visitor
Posts: 14
Registered: ‎10-30-2018

Re: Visual level filter is ignored on Power BI Service

Hi,

 

It looks like I've found what was the problem. I have created selection of bookmarks. And when I created a bookmark for this particular page with this visual, I hadn't had the filter applied yet. So I applied the filter one more time how I want the visual to be and then created a bookmark. Now for all report viewers the filter is applied when they press on bookmark button.

 

I'm still quite new in Power BI so I didn't know that filters affect also the bookmarks.

 

Thank you for the help anyway!

 

Br,

Edgars