Forum Discussion

vipinbharti121's avatar
vipinbharti121
New Member
5 years ago
Solved

Filter a slicer based on selection in Table

I have one power bi Table : University College Subjects A X Maths, science, sociology B Y Science, History C Z PE, Arts, ED Here subjects column is concatenated.  There is o...
Interesting Links
Need Help
Tips and Tricks
  • v-yingjl's avatar
    v-yingjl
    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 Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi vipinbharti121 ,

 

In PBI the slicer visualizations work differently from other visualizations. If you are abble to filter information on any visualization to other, being the slicer a filtering visualization you can only filter slicers with the filter pane or with other slicers you are not abble to select data from a table or a chart and have the slicer being filtered.