Changing Slicer Search type

[GreenR1]

I'm using a Slicer but the default setting is to search for data "Contains", is there a way to change this so that data is searched on "Starts With".

Reason for this is that we are searching against MAC addresses and having the default behaviour is pulling back too much information.

I cannot see or find a way to change the default search type.

thanks
Richard

[GreenR1]

Thanks, whilst not perfect using the Test Search slicer has provided an acceptable solution.

[GreenR1]

Thank you for that, i'll have a look at these suggestions

[v-linyulu-msft]

Hi,@GreenR1  

Thanks for the quick reply.
 

Looking forward to your latest reply.
 

I wish you all the best in your life.

 
Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

[bhanu_gautam]

@GreenR1 , You can check custom visuals for this 

[GreenR1]

Can you expand on this please? @bhanu_gautam 
thanks

[v-linyulu-msft · Accepted solution]

Thanks for the reply from bhanu_gautam , please allow me to provide another insight:

Hi, @GreenR1 

Regarding the issue you raised, my solution is as follows:

1.First I have created the following table and the column names and data are the data you have given:

2.Then we create the following calculated columns as slicers: 

Column = LEFT('Table'[value],2)

3.Here's my final result, which I hope meets your requirements.

4.Of course, you can use custom visuals like this: 

5.Here's my final result, which I hope meets your requirements.

Please find the attached pbix relevant to the case.

 
Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.