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
are Status 1, 2 & 3 columns in your source data or attributes of one column? Is the slicer table connected with main table using a relationship?