cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Advanced Filtering option disappeared in Filter Pane

Dear All, 

The past few days I have been experiencing some strange issues with the Filter Pane. 

 

Before, in the Filter Pane, I could choose the filter type either 'Advanced filtering, Basic filtering, or Top N'. The Advanced filtering is something very useful when it comes to filtering for a specific keyword in texts. 

 

However, when I published the file onto Power BI Web recently, the Advanced filtering option has disappeared, and now I cannot filter for a specific keyword anymore. 

 

I am wondering if this is a bug from Power BI side? How can I have the Advanced filtering and the Top N filter type like before?

 

Please see the 2 screenshots below:

1) The power bi file in desktop locally where I can choose Advanced filtering:

In Power BI Desktop (local file).PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2) The power bi report after I have published onto the Web, the Advanced filtering has disappeared, and only a generic field for Search appears: 

After Publish on Power BI Desktop.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

If you could please help me to solve this issue, it would be greatly appreciated. 

Many thanks,

Trang 

7 REPLIES 7
Andy_DS Frequent Visitor
Frequent Visitor

Re: Advanced Filtering option disappeared in Filter Pane

We can confirm we are experiencing the same problem.

 

It appears this could be a bug with the latest release.  Is it possibly connected to the changes made to the 'new filter experience'?

 

https://docs.microsoft.com/en-us/power-bi/power-bi-report-filter-preview

 

Regards

Andy DS

Community Support Team
Community Support Team

Re: Advanced Filtering option disappeared in Filter Pane

hi, @Anonymous 

I have tested on my side, It works well

Could you please share your simple sample pbix file for us have a test?

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Langejans Frequent Visitor
Frequent Visitor

Re: Advanced Filtering option disappeared in Filter Pane

Hai,

We're having the same problem. You could normally choose filtertype (advanced / basic etc) in Power BI service, but now you only see the type that has been selected in Desktop (either advanced or basic).  

We really want the option back for users to choose which type of filtering they want to use.

 

I think it's the same problem that Trang is describing.

 

Regards,

Alies 

 

filter service.JPG

Andy_DS Frequent Visitor
Frequent Visitor

Re: Advanced Filtering option disappeared in Filter Pane

We are experiencing this bug in the server version of Power BI.  From the comments above it sounds like it is in the desktop version too.

Langejans Frequent Visitor
Frequent Visitor

Re: Advanced Filtering option disappeared in Filter Pane

With us it's in service as well, after we publice a report, te filtertype dissapears as an option.

Desktop seems to be working fine.

 

Regards Alies

chrisl Frequent Visitor
Frequent Visitor

Re: Advanced Filtering option disappeared in Filter Pane

I am experiencing an issue of the entire filter pane disappearing and I cannot get it back.

Andy_DS Frequent Visitor
Frequent Visitor

Re: Advanced Filtering option disappeared in Filter Pane

Hi

 

This is now working OK from our end.

 

I have been on vacation so can cannot confirm when it began to work OK.  As of May 9th '19 it has worked fine.

 

thx

Andy

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 300 members 3,478 guests
Please welcome our newest community members: