Forum Discussion
Filter table data based on Slicer selection
Hello , I have a question on applying filter based on Slicer selection. I am using direct connection to connect a database. Q : we have Slicer Table as an example which will display in power ...
Hi Anonymous
You can create the following measure and use it as a filter on the visual. Set it to show items when the value is 1. If you don't select any status, it will show all.
Filter Flag = SWITCH(SELECTEDVALUE(Slicer[Status]), "Status 1",IF(SELECTEDVALUE('Table (2)'[Status1])="Y",1,0), "Status 2",IF(SELECTEDVALUE('Table (2)'[Status2])="Y",1,0), "Status 3",IF(SELECTEDVALUE('Table (2)'[Status3])="Y",1,0), 1)Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi Anonymous
You can create the following measure and use it as a filter on the visual. Set it to show items when the value is 1. If you don't select any status, it will show all.
Filter Flag =
SWITCH(SELECTEDVALUE(Slicer[Status]),
"Status 1",IF(SELECTEDVALUE('Table (2)'[Status1])="Y",1,0),
"Status 2",IF(SELECTEDVALUE('Table (2)'[Status2])="Y",1,0),
"Status 3",IF(SELECTEDVALUE('Table (2)'[Status3])="Y",1,0),
1)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.