Issue with Bookmarks

[Anonymous]

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.

[dax]

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.

[amitchandak]

To help you further I need pbix file. If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[SivaMani]

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]

Hi Siva,

Thanks for your reply.

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

[dax]

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.