Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
ad8833
Advocate II
Advocate II

Issue with the Filter type (Basic/Advanced) getting disabled all of a sudden

Suddenly the Filter type option(basic/advanced) has got disabled and is not showing up on any of the filters in Power BI service.Many users in my organization have reported this issue and I faced the same.Plkease suggest If anyone is aware about any workarounds.

2 ACCEPTED SOLUTIONS
ad8833
Advocate II
Advocate II

Great News!!!!The filters are back now.

View solution in original post

Hi @ad8833 ,

It's pleasant that your problem has been solved, don't forget to mark one reply as Answered to close this topic.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
callenbkd
Regular Visitor

Greetings. I've selected the option to go to solution but I can't see the solution. If somebody would reply here, I would be grateful. 

ad8833
Advocate II
Advocate II

Great News!!!!The filters are back now.

Hi @ad8833 ,

It's pleasant that your problem has been solved, don't forget to mark one reply as Answered to close this topic.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tlaresch
Advocate II
Advocate II

We are having the same issue, and it is a BIG deal for us.  Users have lost filter functionality that they use regularly.

 

We have reports published to the Power BI Service - some long ago, some more recent - with some filters defaulting to Basic, some defaulting to Advanced.  In all the published reports, users are no longer able to toggle between Basic and Advanced.  Developers are able to switch modes when looking at the reports in the Power BI Desktop.

 

Please let us know how to get back this functionality!

Anonymous
Not applicable

same issue here

v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @ad8833 ,

Which situation do you want to add the filter for your report? Reading view or Edit view? Only in Edit view, you could change the filter types:

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-filters-and-highlighting#filters-in-readi...

And make sure the type of your data in the column that you want to filter is Text, the text column could use the Basic/Advanced filter.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I am talking about Basic filtering and Advanced filtering options.Earlier , users were able to use them as part of filtering but suddenly it has been disabled.

Hi @ad8833 , @tlaresch,  @Anonymous
It is a known issue and I have reported internally, I will update the issue as soon as possible once I got any information.

 

Regards,

Daniel He
 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Unfortunatley , from last couple of days there are multiple issues that we are facing with Power BI:

 

1) Unable to use "Test as Role" or "login as" functionality.

2)Filtering type issue(basic/advanced) in PBI service.

3)Add/Remove roles from Security bucket(figured out a workaround but still).

 

These issues are really hindering our work and kind of getting escalated.Please get them fixed so that we can function smoothly.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.