Forum Discussion

jkunkoski's avatar
jkunkoski
New Member
9 years ago

Power BI Desktop Filter Multi Value Field/Column

I have two data sources from two Excel files. Both files come from SharePoint Prem 2013. One field is from a Multi Select Field in a SharePoint list so the data in each row is messy, as follow: Row1/...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

jkunkoski

You can use a measure as below. See more detail in the attached pbix.

 

IsShown =
VAR ROWCNT =
    COUNTROWS (
        FILTER (
            Table1,
            SEARCH ( LASTNONBLANK ( Table2[Column1], "" ), Table1[Column1], 1, 0 ) > 0
        )
    )
RETURN
    IF (
        (
            ISFILTERED ( Table2[Column1] ) && HASONEVALUE ( Table2[Column1] )
                && ROWCNT > 0
        )
            || NOT ( ISFILTERED ( Table2[Column1] ) ),
        1,
        BLANK ()
    )

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Eric, thanks for your post. I tried to get the slicer working with two or more selections at same time but I could not. I wonder if its possible to filter for instance 5G and 7G at once. Best regards, Augusto