Forum Discussion
Change visuals when i select all values and select individual values in slicer
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?
- Anonymous1 year ago
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:-
Create a Blank Button(Name this button "Select All") and a Back button.
-
-
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.
-
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.
- This way, when you click the "Select All" button, it will navigate to the bookmark showing the waterfall chart from Table 2.
- 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.
-
2 Replies
- danextian
Super User
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
- AnonymousNot applicable
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:-
Create a Blank Button(Name this button "Select All") and a Back button.
-
-
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.
-
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.
- This way, when you click the "Select All" button, it will navigate to the bookmark showing the waterfall chart from Table 2.
- 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.
-