Forum Discussion
Filter a slicer based on selection in Table
- 5 years ago
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.
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 Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.