The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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
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.
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.
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.