Forum Discussion

Laurent88's avatar
Laurent88
New Member
2 years ago
Solved

Slicer filtering

  Hi Community   I am a recent user of PowerBI and so far, it works great for me. I however have a question that I really struggle to answer, despite browsing through the forum. Here it is:   In...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Laurent88 

    You can refer to the following sample.

    Sample data

    Samle slicer data 

    Create a measure and put the measure to the table visual filter

    Measure =
VAR a =
    COUNTROWS (
        FILTER (
            VALUES ( Slicer[Slicer] ),
            CONTAINSSTRING ( SELECTEDVALUE ( 'Table'[Column2] ), [Slicer] )
        )
    )
RETURN
    IF ( a > 0, 1, 0 )

     

    Output

     

    Best Regards!

    Yolo Zhu

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

     

HotChilli's avatar
HotChilli
Community Champion
2 years ago

For simple models, it would be possible to have the data in the format shown but for a more database-like structure, the AnimalList column would be split and then the subsequent columns unpivotted. It would turn out like this:

1 Elephant
1 Lion
2 Lion
3 Elephant
3 Giraffe

You can filter this with an Animal Dimension table related 1:m to this table.

If required, you can build animal lists with a measure using CONCATENATEX