Changing the visibility of visuals

[Anonymous]

Hello all

I'm planning a new project in BI, and looking at which approach would be best.

In Excel, it is possible to use VBA to change the visible function to display different visuals based on user selection (show or hide them completely)

Is there a similar function in BI, where I could show or hide certain visuals based on the user selection (in this instance a chiclet slicer selection).

The datasets will be drastically different, so I won't be able to use the same visual for each, hence why I'm looking at this type of solution.

Any help would be appreciated.

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may use bookmarks and buttons to achieve that.Below are some articles for your reference.

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

http://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

http://www.victorrocca.com/using-bookmarks-to-show-hide-information-in-your-power-bi-report/

Regards,

Cherie

[Anonymous]

Hi @v-cherch-msft 

This is pure gold!

Thank you so much!

Kind Regards