Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
EaglesTony
Post Prodigy
Post Prodigy

How do I filter multiple rows ?

Hi,

 

  I have the following columns in my data:

 

ID              Label1                           Label2

123           GREEN, YELLOW            BLUE,RED

456           ORANGE                        GREEN

456           GREEN                           PURPLE

456           RED                                BLUE

456          RED                                 YELLOW

 

What I am trying to do is combine filters so to speak, for example

 

Filter #1: Label1 contains GREEN or YELLOW

Filter #2: Label2 contains GREEN or YELLOW

 

This would results would be:

 

123

456 (Where Green is in Label2)

456 (Where Green is in Label1)

456 (Where Yellow is in Label2)

1 ACCEPTED SOLUTION

I was able to solve it doing the following:

 

1) Select both columns

2) Drop down one of the columns and do "Text Filters" and click on "Advanced"

 

Now it allows to select multiple columns.

View solution in original post

2 REPLIES 2
dufoq3
Super User
Super User

Hi @EaglesTony, try this.

Now you can just filter value 1 in [Keep Row] column.

 

Result

dufoq3_0-1713357392699.png

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQyVtJRcg9ydfXTUYh09fHxDwfynXxCXXWCXF2UYnWilUxMzYBC/kGOfu6uILVFqal5SBJgvUA6IDQowMcVSQKkH2IUhiDUothYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Label1 = _t, Label2 = _t]),
    Ad_KeepRow = Table.AddColumn(Source, "Keep Row", each 
        [ a = Text.SplitAny([Label1], " ,") & Text.SplitAny([Label2], " ,"),
          b = if List.ContainsAny({"GREEN", "YELLOW"}, a, Comparer.OrdinalIgnoreCase) then 1 else 0
        ][b], Int64.Type)
in
    Ad_KeepRow

Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

I was able to solve it doing the following:

 

1) Select both columns

2) Drop down one of the columns and do "Text Filters" and click on "Advanced"

 

Now it allows to select multiple columns.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.