cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBiIsFun
Frequent Visitor

Removefilters not working in PBI Service

Hi All,

I'm trying to compare the data from one category to the average of all the categories.  I've used Removefilters( Projects[Category]) and it works great in PBI Desktop but stops working when I publish to the service!.... Is this a bug?  It seems so from my end.

Thanks,

Sarah

1 ACCEPTED SOLUTION

@PowerBiIsFun ,
Try re-publishing once to the workspace and open it in incognito mode.

If issue still stays, please raise a ticket to MS Support. They can open the workspace logs and check the issue.

PBI_SuperUser_Rank@1x.png  

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

View solution in original post

3 REPLIES 3
Anand24
Super User
Super User

Hi @PowerBiIsFun ,
It should be a bug since you are saying it is working in PBI Desktop but not in PBI Services because there is no DAX function that would create issue in only Services.

 

Please check the below though:
1. Try opening the report in Incognito mode so that browser cache is not affecting the report

2. Try publishing the report again

3. Try publishing the report to another workspace or my workspace to check any workspace issue

4. If none of the above feeds you appropriately, raise a ticket with MS Support reporting this as a bug 

PBI_SuperUser_Rank@1x.png  

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

Hi @Anand24 !

Thanks for the info - it turns out the removefilters function works in another workspace.... so what do I do now?  Of course the workspace where removefilters isn't working is my production workspace!  😞  Both are in a premium environment.

@PowerBiIsFun ,
Try re-publishing once to the workspace and open it in incognito mode.

If issue still stays, please raise a ticket to MS Support. They can open the workspace logs and check the issue.

PBI_SuperUser_Rank@1x.png  

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

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors
Top Kudoed Authors