Change visuals when i select all values and select individual values in slicer

[Joel_sony]

Hi all ! ,
I've been looking all over to find a solution for this, I'm having 2 waterfall charts coming from 2 tables. And i have a common slicer. I want to show waterfall chart from table 1 when i 'select all' values in the slicer and i want to show waterfall chart from table 2 when i select 'individual values' from the slicer. Is there a solution to this?

[Anonymous · Accepted solution]

Hi  @Joel_sony, hello danextian, thanks for your concern about this case.

Currently, Power BI doesn't support using slicers to directly switch visuals.

However, you can use a workaround with bookmarks and buttons. 

Please check the following steps:

1. Create a Blank Button(Name this button "Select All") and a Back button.

2. 

3. Hide Selection and Set Up Bookmarks:

   • Create a bookmark for the waterfall chart from Table 1 and hide the waterfall chart from table 2.
   • Create another bookmark for the waterfall chart from Table 2 and hide the waterfall chart from table1.

4. Assign Actions to the Button:

   • Assign the "Select All" button to navigate to the bookmark with the waterfall chart from Table 1.
   • Create another button for individual selections and assign it to navigate to the bookmark with the waterfall chart from Table 2.
5. 
6. This way, when you click the "Select All" button, it will navigate to the bookmark showing the waterfall chart from Table 2.
7. For individual selections, use Back button to navigate to the bookmark showing the waterfall chart from Table 1.

Result for your reference:

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian]

Hi @Joel_sony 

Can you please post a workable sample data (not an image) and your expected result from that? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523