cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jkunkoski Visitor
Visitor

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/Column1: 5G;#;API;#;6G;#, Row2/Column1: API;#;6G;#, etc. The second data source provides a cleaned up version but DOES NOT match the values 1 for 1 of the first data source (above, Column1).

 

The second data source is one column with one value in each cell/row, for example, Row1/Column1: 5G, Row2/Column1: 6G, etc.

 

I'm trying to make it so the user can select a control containing all the values from the second data source that will filter rows in the first data source where that value exists. IF selection of data source2 matches a value in datasource1, filter charts and everything in datasource1 accordingly. Can someone help? I'm brand new to Power BI

2 REPLIES 2
Moderator Eric_Zhang
Moderator

Re: Power BI Desktop Filter Multi Value Field/Column

@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 ()
    )

Capture.PNGCapture2.PNGCapture3.PNG

Highlighted
AugustoGMAraujo Frequent Visitor
Frequent Visitor

Re: Power BI Desktop Filter Multi Value Field/Column

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 206 members 1,995 guests
Please welcome our newest community members: