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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
roxieli123
Frequent Visitor

How can I put multiple "Contain" filter on one column?

Hi, 

I have this table with thousands of account numbers, which have different start letters. 

for example, account# can be in the form of: 

ABC######, ASD######, ADF######, AGH#######, BFD######, EIO#######, ERT######, etc, and there are thousands of account# with each starting letters. 

 

The table visual I want contains account#, and some other columns. If I only want the table to show account# in the form of ABC#####, ASD#####, ADF######, AGH######, how can I do this?

 

I can set "Filter on this visual", however it will only let me add at most 2 filters, seen below, however I need all four. 

2019-08-15_14-35-44.png

I know I can filter in Query editer, however I cannot do this because my other visuals on the dashboard need all the account# not only the filtered ones. 

2 ACCEPTED SOLUTIONS
RobbeVL
Impactful Individual
Impactful Individual

You could create a new column with only the first 1 letters. (a category)

Then you could do basic filtering on that category.

 

Do you understand my explenation?

 

Robbe

View solution in original post

Ashish_Mathur
Super User
Super User

Hi,

You can create a calculated column formula

Cat = LEFT(Data[Account],3)

Now create a slicer and drag this column in there.  Select whatever you want.

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

You can create a calculated column formula

Cat = LEFT(Data[Account],3)

Now create a slicer and drag this column in there.  Select whatever you want.

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
RobbeVL
Impactful Individual
Impactful Individual

You could create a new column with only the first 1 letters. (a category)

Then you could do basic filtering on that category.

 

Do you understand my explenation?

 

Robbe

Hi, Thank you for your response that works, 

what if in the future I need the same thing but with cube connection(which cannot add new columns or do query editor), is there any way to achieve the same result with measure? Lets assume the account# I want does not necessarily all start with 'A', hence filtering on all three starting letters will be needed. 

 

@Ashish_Mathur

 

 

You are welcome.  Share some data and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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