Forum Discussion

prateekraina's avatar
prateekraina
Memorable Member
8 years ago

Bookmarks remove report level filter

Hi Guys,   I have a report in which i send filters through URL. Recently i have created bookmarks in which i show and hide a map visual by creating a toggle button approach.   However, after pub...
Need Help
prateekraina's avatar
prateekraina
Memorable Member
8 years ago

Hi Anonymous,

 

Thanks for the response.

 

I am not using Publish to web feature. I have simply embedded a report in my web app and i am passing filters to it via URL.

 

Prateek Raina

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi prateekraina,

 

You can check below link which told about the limitation about bookmark feature:

Limitations and considerations

In this preview release of the bookmarks, there are a few limitations and considerations to keep in mind.

  • Custom visuals do not work with bookmarking if they are the source of the filter. If you're using custom visuals to filter elements on a page (for example, the chiclet slicer) and return to that page using a bookmark, the page may be filtered but the custom visual won't be updated to show how the page is being filtered.
  • Cross-highlighting status for a report pane is not saved when you create a bookmark.
  • If you add a visual on a report page after creating a bookmark, the visual will be displayed in its default state. This also means that if you introduce a slicer into a page where you previously created bookmarks, the slicer will behave in its default state.
  • Moving around visuals after a bookmark has been created will be reflected in the bookmark.
  • You must have at least one bookmard in your report, when you publish it to the Power BI service, in order for bookmarks to be available in the service. This is a requirement for each report you publish.

 

 

Use bookmarks to share insights and build stories in Power BI (Preview)

 

Regards,

Xiaoxin Sheng

  • prateekraina's avatar
    prateekraina
    Memorable Member
    8 years ago

    Hi Anonymous,

     

    Thanks for this information.

     

    I agree to these Limitations in the preview mode. However, the limitation is set in terms of slicer in highlighted 3rd Point.

    They have not mentioned anything related to report level filters.

     

    Also, ideally report level filters must override and filter the bookmarks. What do you say?

     

    Prateek Raina 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi prateekraina,

       

      >>Also, ideally report level filters must override and filter the bookmarks.

      Actually, I test with report level filter and found it not affect the saved bookmarks. If you click on bookmark, it will restore visualizations to status you save/add the bookmark.

       

      Regards,

      Xiaoxin Sheng

      • prateekraina's avatar
        prateekraina
        Memorable Member
        8 years ago

        Hi Anonymous,

         

        Let me make the picture more clear.

         

        Consider you have a report in which you have a single page and you show a line chart for say Temperature, Humidity etc for thousands of sensors.

        You publish this report and later embed this with your Web Application through which you pass filters in this Power BI report.

         

        Example:
        Report URL: https://app.powerbi.com/reportEmbed?reportId=<REPORTID>

         

        Now if i want to see the report for Sensor1 then i will choose Sensor1 in the dropdown of my webapp which will fire below URL:
        https://app.powerbi.com/reportEmbed?reportId=<REPORTID>&$filter=Sensor/SensorName eq 'Sensor1'

         

        So far so Good ?

         

        Now, what i do is i need to showcase a map in the same page of the report in which i will show data of GPS Sensor. So what i do is i add a map on top of line chart and hide it.
        I create two bookmarks; 1 with Map and 1 without Map.

        I link these bookmarks to a toggle image which acts as my toggle button. So now clicking on this image should either show me Bookmark 1 or BookMark 2.

         

        I now publish this updated report.

        Now when i choose say Sensor2 which is my GPS sensor in webapp, following URL is hit:

        https://app.powerbi.com/reportEmbed?reportId=<REPORTID>&$filter=Sensor/SensorName eq 'Sensor2'

         

        Everything is fine till now, the report loads fine and shows me data for Sensor2. Now if i hit my toggle button which should display me the line chart, the Sensor2 filter is lost. The report shows me data across all the sensors.

        So my purpose of passing filters through URL is not served.

        i hope this scenario will clearly make you understand what i am not able to achieve. This surely cannot be a limitation.

         

        I would request you to kindly upvote the issue i have raised on the community which already has been accepted. Here is the link.

         

        Prateek Raina