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 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