cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kik1988
New Member

Exlcuding a list of 100 PostCodes in 1 visualization without ticking 100 boxes.

Hello!

 

I am new here so hello everyone! Excited to interact with other Pbi users, I was feeling totally alone in this journey.

 

I need some help with the following issue...

 

I have multiple tables showing this year sales vs last year sales. Each one of these tables are filtered by different postcodes. This is easy as each table has 1-10 different postcodes. I simply tick the boxes in the visualization filter.

 

The problem arises in the last table, i'd like to show all postcodes excluding the ones i used previously in the beforementioned tables.  I have a list of 100 postcodes I'd like to exclude from a +7000 postcode list. I want to avoid doing this manually.

 

Is there a way to use advance filtering and paste a list of postcodes, maybe sepparated by commas?

 

Hoping you can help me,

 

Cheers

 

Enrique

1 REPLY 1
amitchandak
Super User
Super User

@kik1988 , Create a table with those 100 postcode and use not in

 

countrows(filter(Table, not Table[Postcode] in values(exclude[postcodes]) )  )

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors