Two charts in the same position by switching button?

[YunJ]

Hello!

I'm wondering whether pbi has a function that:

I have two buttons, when clicking button1 it shows one chart, when click button2 it shows another chart in the same position.

Thanks

Yun

[v-frfei-msft · Accepted solution]

Hi @YunJ ,

Bookmark should help you. I have created a sample for your reference, please check the pbix as attached.

[Anjan_Luckyboy]

Is it possible without using bookmarks? If we have slicer in case? 

[v-frfei-msft · Accepted solution]

Hi @YunJ ,

Bookmark should help you. I have created a sample for your reference, please check the pbix as attached.

[YunJ]

BTW, I'm wondering how to attach a pbix file here? Thanks!

[danno · Accepted solution]

no problem, you can add attachments to an original post, I can't see a link in a reply to do that.  

could you mark my post as a solution so I can get credit for it? 

[YunJ]

Thanks a lot!

[danno]

Hi, you can use bookmarks, one for each chart.  

1. create 2 bookmarks, and set the options to Selected Visuals. 

2. Create 2 buttons, one for each visual.
3. Use the Selection pane in Power BI to show / hide each of the visuals. 

 - Firstly hide one visual and show the other visual, then update your first bookmark. 

 - then reverse the hidden visual and update the second bookmark

 4. Apply your bookmarks to each of your buttons. 

If you want the effect of a single button, then overlap the buttons and use show / hide on each button (remembering to update your bookmarks to hide each button alternately. 

Let me know if this helps

[YunJ]

Thanks Danno!

[danno]

here is a worked example: https://visualbi.com/blogs/microsoft/powerbi/toggle-chart-table-power-bi/