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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Kerslaing
Helper I
Helper I

Fuzzy Search with Slicer using List of values

I have a table with lists of software and the type they are, ie , pc, andoid, ios ( these are each held with a Y in a separate column)  This is displayed as a list rather than individual fields and i have done that using text.combine so have data like

 

software1  pc

software2  pc;android

software3

software4 ios

 

they want to be able to use a slicer to select a specific type, ie if i select PC they will see software 1 & 2.  Ive managed to get this working using the Text Filter visualisation where they type in pc and it returns the correct  records.

 

But does anyone know if this is possible by having a slicer with PC, Android  etc that they can select from. I can create a hard coded list of the types, as theres only 6 but how to get that to search through the combined list of  pc;android?

 

Thanks

3 REPLIES 3
Kerslaing
Helper I
Helper I

No its not resolved.

 

i only want to see a slicer with PC, Android, IOS   in the list  but this uses the fuzzy search to search through a field that might have pc;android, pc, pc;ios etc.  if i create a list of all the permetations they will appear in the slicer.

 

 

if i create a 

v-yalanwu-msft
Community Support
Community Support

Hi,  @Kerslaing ;

Is your problem solved?  If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft
Community Support
Community Support

Hi, @Kerslaing ;

Fuzzy filtering generally uses text filter or smart filter;
If you use slicers, you need to create a list of many permutations and combinations, and if the data is small and can be listed directly, it is not feasible to have more data.

vyalanwumsft_0-1664245932454.png


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors