Forum Discussion

PowerBiIsFun's avatar
PowerBiIsFun
Frequent Visitor
4 years ago
Solved

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

  • Anand24's avatar
    Anand24
    4 years ago

    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.

     

    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

3 Replies

  • 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 

     

    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

    • PowerBiIsFun's avatar
      PowerBiIsFun
      Frequent Visitor

      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.

      • Anand24's avatar
        Anand24
        Icon for Super User rankSuper User

        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.

         

        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