Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to filter a table?

Hello   The table I download from the source has some rows that I want to delete them. To identify these rows, I will need to use criteria like [Column1]=*something_not_case_sensitive1* OR [Column...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi.

 

I'll assume the rows in the source are there for a reason.  Your download of the data into Power BI means you're working on a local copy.  You'll want to remove rows from that local copy within Power BI.  You'll need to make some statements in your data, to filter down the rows you want removed.

 

Without seeing your data, it's very difficult to give you a detailed list of actions to take.

 

Google is a generally good source for things...not knowing more specifics I would search for things like:

 

"Power Query Filtering undesired Rows"

 

you'll get the idea.

 

 

Or post your data table here and what you want filtered out and we can help.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks, I cannot post the real data as it is confidential but you can use the table with the values below:

 

A1;B1;C1

A2;B2;C2

A3;B3;C3

A4;B4;C4

 

I want to remove the rows where in column B, the value equals *B2* or *B3* (case-insensitive with * being wildcards).

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I'm not sure if you can filter a column directly with an insensitive case filter. 

    What you can do however is duplicate the column as all upper case and then filter on that

     

     

    just input your desired text string into that filter as uppercase and you should be good to go.