Forum Discussion

Joel_sony's avatar
Joel_sony
Frequent Visitor
1 year ago
Solved

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?

  • Anonymous's avatar
    Anonymous
    1 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:

     

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

    2. 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.
    3. 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.
    4. This way, when you click the "Select All" button, it will navigate to the bookmark showing the waterfall chart from Table 2.
    5. 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

  • Anonymous's avatar
    Anonymous
    Not 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:

     

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

    2. 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.
    3. 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.
    4. This way, when you click the "Select All" button, it will navigate to the bookmark showing the waterfall chart from Table 2.
    5. 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.