Change visual when clicking on filter in Power BI

[amirabedhiafi]

I have the following filter : 

Activity : Salaries, Headcount, Absence

• I want when to click on the Dept1 I show a specific visualization in the same page : a bar char to calculate the salaries
• I want when to click on the Dept 2 I show a specific visualization in the same page: a pie chart char to calculate the headcount
• I want when to click on the Dept 3 I show a specific visualization in the same page : a pie chart char to calculate the absence

How can I achieve this ?

[v-easonf-msft · Accepted solution]

Hi,  @amirabedhiafi 

You can refer to this post to create Bookmark buttons saved with visibility of your object (by using the Selection pane).

how-to-add-button-using-bookmarks-in-power-bi/ 

Please check my sample pbix file for more details.

Best Regards,
Community Support Team _ Eason

[ftgpdx]

Hello, 

To confirm, you want each of the filter options to change a different visualization within the same page? If so, you can choose Edit Interactions. https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

Select your visual, then Format from the Ribbon, then Edit Interactions at the far left. An icon will then appear next to each visual. Choose None for the ones you don't want it to interact with. 

[amirabedhiafi]

I want the filter to show the first visualization if I change the same filter the first visualization to be hidden and a second visualization to appear instead.

[ftgpdx]

Thanks for clarifying. This will definitely have to be solved with bookmarks. I've done something similar by placing a small button over the slicer option so users think they're clicking a button when in actuality they're activating a bookmark. 

[amirabedhiafi]

Having many bookmarks with a large dataset can have an impact on the performance?

[ftgpdx]

That's very unlikely. Bookmarks make up a very small part of the layout file (https://www.fourmoo.com/2017/05/02/what-makes-up-a-power-bi-desktop-pbix-file/) so you'd have to have a lot before you notice any sort of performance issues. 

[amirabedhiafi]

But if a bookmark refers to a whole page and for that page I have a large dataset to be loaded to it can lead indirectly to performance issues even if it is a very small part of the layout file.

[ftgpdx]

A bookmark does not necessarily refer to an entire page or even the current state of the data within that page. A bookmark can save only the display settings for a handful of visuals. 

This might be the best video I could find on the topic: https://youtu.be/xCMqWEvSkAs?t=264

Skip ahead to 7:00 (https://youtu.be/xCMqWEvSkAs?t=420) to see exactly how to toggle the displays for only a handful of visuals. 

For verifying performance, it would be worth creating a copy of your report, doing the adjustments mentioned above, then running the Performance Analyzer to determind exactly how the report performs. 

[ryan_mayu]

@amirabedhiafi 

maybe you can try to use bookmarks or buttons to jump among three pages. 

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

https://docs.microsoft.com/zh-cn/power-bi/create-reports/desktop-buttons

[amirabedhiafi]

It is in the same page. Is it possible ?

[ponnusamy]

@amirabedhiafi : Yes , manipulating the visuals , layout etc using bookmarks in the same page is possible. You will need to play with hide and show options.

[ryan_mayu]

@amirabedhiafi 

so far I don't think it's possible. I haven't reviewed the new features for several months. Let's wait for experts or community support team to provide you the definitive answer.