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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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

8 REPLIES 8
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
Employee
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors