Forum Discussion

Powerbi_me's avatar
Powerbi_me
New Member
1 year ago
Solved

Show/hide visuals with Slicer

Hello Team,   I am working on a project and the slicer has the group names. ex - India, Australia, New zealand   i have separate donut visuals for the three groups on the overview page. Now if ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Powerbi_me 

     

    Thank you very much MFelix and 123abc for your prompt reply.

     

    For your question, here is the method I provided:

     

    Here's some dummy data

     

    “Table”

     

    Create a new table to use as a slicer.

     

    Slicer Table = SELECTCOLUMNS('Table', "Group", 'Table'[Group])

     

     

    Create a measure to determine the "Group" value selected by the slicer.

     

    Group Select = 
IF(
    ISFILTERED('Slicer Table'[Group])
    &&
    SELECTEDVALUE('Slicer Table'[Group]) = SELECTEDVALUE('Table'[Group]),
    1,
    0
)

     

    Apply the following filter criteria to each donut visual:

     

     

    You can get:

     

     

    Regards,

    Nono Chen

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

123abc's avatar
123abc
Icon for Community Champion rankCommunity Champion
1 year ago

You can achieve this in Power BI by using bookmarks and selection panes. Here’s a step-by-step guide:

  1. Create Bookmarks:

    • Go to the “View” tab and enable the “Bookmarks Pane” and “Selection Pane”.
    • Create a bookmark for each group (India, Australia, New Zealand) by setting the visibility of the respective donut visual and hiding the others.
    • Name each bookmark accordingly (e.g., “India View”, “Australia View”, “New Zealand View”).

  2. Set Up the Slicer:

    • Add a slicer to your report with the group names (India, Australia, New Zealand).

  3. Link Bookmarks to Slicer:

    • Use the “Selection Pane” to control the visibility of each visual.
    • Create a measure that captures the selected value from the slicer.
    • Use this measure in a DAX formula to dynamically update the visuals based on the slicer selection.

  4. Add Buttons for Navigation:

    • If you have drill-downs or action buttons, you can add buttons to your report and link them to the bookmarks.
    • Go to the “Insert” tab, add a button, and set its action to navigate to the corresponding bookmark.

Here’s a simple DAX example to get you started:

SelectedGroup = SELECTEDVALUE('YourTable'[GroupName])

Then, use this measure to control the visibility of your visuals.

If you need more detailed steps or run into any issues, feel free to ask! 😊