Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Visual level filter is ignored on Power BI Service

Hi,

 

I have an issue with Visual level filter. In Desktop I have added a Visual level filter to one of my charts (Show items when the value is less than 16). But on the Power BI Service the same filter is ignored. I can see that this filter has been added but it is filtered as All, it just ignores what I've selected on the Desktop.

 

Any ideas why this is happening?

 

Thanks in advance!

 

Br,
Edgars

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi,

     

    It looks like I've found what was the problem. I have created selection of bookmarks. And when I created a bookmark for this particular page with this visual, I hadn't had the filter applied yet. So I applied the filter one more time how I want the visual to be and then created a bookmark. Now for all report viewers the filter is applied when they press on bookmark button.

     

    I'm still quite new in Power BI so I didn't know that filters affect also the bookmarks.

     

    Thank you for the help anyway!

     

    Br,

    Edgars

9 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous,

     

    Based on my test, I cannot reproduce your issue here by using the Power BI desktop version 2.65.5313.841 64-bit (December 2018). Did you apply filter after editing the visual level filter?

    Regards,

    Frank

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-frfei-msft,

       

      I have a version 2.65.5313.621 64-bit (December 2018) and yes, I applied the filter after editing the visual level filter - pressed enter and the Apply filter button became grey/unactive. See screenshots below how it is for me. First is what I see on the Desktop and the second one what I see on the Service. Filter - Top 10 Case Categories.

      DesktopService

      Br,
      Edgars

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        v-frfei-msft & GilbertQ

         

         

        What I've noticed is that every time I'm publishing a new version of the report, field "Reset to default" becomes active and yellow. When I press it then everything is correct because then report shows author's default view of the report.

         

        It is the same for other report viewers. They have to press this button every time they enter this report to "activate" that particular filter.

         

        In addition to the fact that filter is being ignored, sometimes the sorting is also ignored on that visual. In the web it sometimes is sorted by the name instead of the amount.

         

        Br,
        Edgars

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    7 years ago
    It should apply the same setting on the filter.

    When you re-upload the PBIX does it prompt you to replace existing dataset?
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi GilbertQ,

       

      Yes, it prompts with a question if I want to replace the existing dataset with this one. I press Replace, the new data is there but this particular filter is not saved. This has happened to some other visuals as well in this report but I managed to find workarounds for those but not for this one yet.. I assume I'll have to write some kind DAX formula that will give me only top 15 values instead of using the filter.

       

      Br,

      Edgars