Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter selections are not saved

Issue:

I've developed a report and I am trying to use card visulatization with some set filters. After moving between different pages/tabs, filters are not persistent and I lose selected filter.

 

Requirement:

I need selected filter option to be always saved, irrespective of publishing or moving between different pages/tabs.

 

Pre-checks:

File is developed in following version of PowerBI - 2.78.5740.1101 (Feb, 2020).

Access - Have all permissions since I'm the developer for that report

Selected settings - Refer attachment below

 

Please help.

 

 

  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    From your example I assume that you select certain filters on slicer from page A and you want them to be reflected on page B correct?

     

    First of all you need to have the same slicer on both pages and syncronize them (you can hide them in one page if you want the selection always be only on one of the pages) then you need to go to the bookmarks right click and turn off the data option.

     

    By default the data option is always replacing the bookmark to the selection that was at the time of the bookmark creation.

     

15 Replies

  • Hi Anonymous ,

     

    When you are refering to filtering not being persistent what do you mean? Do you have a set of filters setup in the visual itself or do you have some slicers that interact witht the card making them calculate with those interactions?

     

    If you want that a visualization always have the same filters no matter what the  selections are you need to make the filters at visual level and then turn off all interactions with other visualizations on the page. Maybe you need also to hide the filter pane so that users don't go there and change the filters.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    I've fixed it, only filters should be created on a page without bookmarks, once those filters are created the bookmark is added and fixed issue. If the page already has a bookmark, just delete it, create the filters, and then create the bookmark.
    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      You don't need to delete the bookmark,
      If you RIGTH click the bookmark and choose update it will pick up the new filters.
      • Anonymous's avatar
        Anonymous
        Not applicable
        That's right. I tried it and it does work. Thank you
  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support

    Hi,  Anonymous 

     

    If I understand your requirement correctly that you want to preserve the interaction between visuals  when the page is switched as below.

     

    If it is , I'm sorry for that it is not supported yet currently.  You can refer to this similar idea.

     

    As someone mentioned ,Interactions are cross-highlights which we can’t save to the report - they are transient state. Slicer and filter selections however are persisted with the report on save.

     

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      v-easonf-msft, MFelix - I meant slicer.

       

      Detailed example:

      Page A: Has an icon with an action link to bookmark of Page B.

      Page B: Has a card visulatisation and value for the card is calculated based on selected filter options.

      Issue: On navigation from Page A to Page B via click of that icon, card value doesn't remain persistent.

       

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

        Hi Anonymous ,

         

        From your example I assume that you select certain filters on slicer from page A and you want them to be reflected on page B correct?

         

        First of all you need to have the same slicer on both pages and syncronize them (you can hide them in one page if you want the selection always be only on one of the pages) then you need to go to the bookmarks right click and turn off the data option.

         

        By default the data option is always replacing the bookmark to the selection that was at the time of the bookmark creation.

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    I have the same problem. I have a page that has graphs with filters, but when jumping to another through one button and then going back to it through another button, the filters have been lost. Who can help us?
      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User

        This seems to be a bug but it happens only on certain times, you should place this on the issues part of the forum.