Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Issue with Bookmarks

Hi all,

I am using bookmarks in power bi to show/hide slicers on the page. There are two bookmarks on same report page:
1. Show months - when selected, "Choose month" slicer gets visible and "Choose quarter" slicer gets hidden
2. Show quarter - when selected, "Choose quarter" slicer gets visible and "Choose month" slicer gets hidden

I have a bar graph on the page, which should so value monthly or quarterly based on the bookmark and slicer selection. For example
if we select bookmark "Show quarter"
"Choose quarter slicer gets visible and we select Jan-mar 19,

In this case bar graph shows result for Jan-mar 19

Similarly if we select bookmark "Show month" then "Choose month" slicer gets visible and we should be able to select any month and bar graph should show the data for selected month.

Issue is, if we select Jan19,Feb19, Mar19, we see the data in bar graph. But if we select any month other than these then we see blank bar graph, no data. I think this is because of the selection Jan-Mar 19 in hidden slicer " choosen quarter". Intreaction between both slicers are turned off.

Please let me know how can i fix this issue, so that the bar graph can work with both slicer independently.

5 Replies

  • SivaMani's avatar
    SivaMani
    Resident Rockstar

    Hi Anonymous,

     

    Is the Data property disabled? Please try disabling it.

     

     

    Hope It will help you!
    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.

    Thanks,

    Siva

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Siva,

      Thanks for your reply.

      I disabled the "Data" property, but still have the same issue. 

       

      • dax's avatar
        dax
        Community Support

        Hi ShanayaK ,

        You could check whether you  set something in filter or other things. And as I mentioned above, could you please inform me your pbix, you could hide the real data and showme your simple sample and your problem, then I will help you more correctly.

        Please do mask sensitive data before uploading.

        Thanks for your understanding and support.
        Best Regards,
        Zoe Zhi

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • dax's avatar
    dax
    Community Support

    Hi ShanayaK , 

    Yes. as mentioned above, if possible, could you please inform me more detailed information(such as your pbix), then I will test this in my environment to see whether this is caused by design or is bookmark issue.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.