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.