Forum Discussion

RobX's avatar
RobX
Icon for Advocate I rankAdvocate I
4 years ago

Activate Bookmarks by Slicer

I have a report that has two line charts.  One that show a single high level value and a second chart has a legend breakdown of the high level chart.

 

I want to toggle between the high level chart and detailed chart when a selection is made in a slicer.  I know bookmarks can be toggled by buttons, but can they be toggled by slicer selections?

 

Chart with no slicer selection:

 

Chart with slicer selection:

 

2 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support

    Hi, RobX 

     

    It’s impossible for the slicer to switch bookmarks, but the effect you want seems to be achievable without bookmarks. I don't know your data, and if you can try to use measure in visual,maybe it can be display in one visual.

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.


    Best Regards,

    Community Support Team _ Janey

  • Hi Rob, 

    I achieved something similar via Switch function. I created an extra table with the names of the measures I am referencing to, and the switch function checked which value is selected. 

    A bit hard to explain without a dataset, but have a look at this video from curbal as well:
    Change measures using slicers in Power BI Desktop- Power BI Tips & Tricks #20 - YouTube

    Does that help? If so, please

    • mark this post as a solution
    • give kudos

    Thanks hashtag_pete