Forum Discussion
Filter a slicer based on selection in Table
Hi vipinbharti121 ,
Basically visuals could not filter slicers so you can use the subjects field to create another table visual as a 'slicer'.
Create this measure, put it in the visual filter and set its value as 1:
Control = IF ( COUNTROWS ( FILTER ( 'Table', CONTAINSSTRINGEXACT ( 'Table'[Subjects], SELECTEDVALUE ( Subjects[Subjects] ) ) ) ) > 0, 1, 0 )Attached a sample file in the below, hopes to help you.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionFollowing on from MFelix comment, you might try using a table visual (instead of a slicer visual) as your "slicer" and instruct users accordingly
EDIT: you might actually be able to use a Slicer with a filter measure applied in the filter pane. Do you have a sample dataset to play with?
Thanks @PaulDBrown
I have tried to create a measure which should filter slicer but yet not succeded.
I will not be able to provide the real data but I will try to replicate the scenerio.
There is one more field, numeric field: Sales of Books of that subject.
| University | College | Subjects | Sales of books |
| A | X | Maths, science, sociology | 35050 |
| B | Y | Science, History | 21520 |
| C | Z | PE, Arts, ED | 12500 |