Forum Discussion
Show/hide visuals with Slicer
- Anonymous1 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.
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.