Forum Discussion
Slicer with search from multiple fields
Thanks Raymundo - your post gave me some more inspiration. I've used the old 'invisible rectangle' trick to solve this.
I've set the slicer to use a hierarchy and then put a white rectangle that is always in front over the column of chevrons.
This gives the look and feel that I was after. Hopefully in the future we'll just have a feature to use one set of fields for items, and a different set of fields for search. But in the meantime, this is pretty close...
Since you are using a slicer visual, you need to be very specific and explicit, there's no way you can achieve this without considering the hierarchy. Synonyms and descriptions only work for Q&A visuals.
Thanks Raymundo.
There isn't a hierarchy though, I have a single table with two columns, Name and Description. I guess there just isn't a way to achieve what I want to do without the hacky solutions I mentioned above!
Still you can create the hierarchy. Right click on Name field > New hierarchy and drag the description field onto the Name. Then use that hierarchy in the slicer.
Thanks Raymundo - but using a hierarchy this way just doesn't achieve the experience I want for my users.
See the screenshot below. Using the hierarchy makes it look messy and confusing, unless there is a way to turn off the chevron and hide the description field from the slicer.
Yeah, hierarchies are not appealing and not user friendly in slicers. You can change the chevron though on Format > Items > Expand/collapse icon. You have as options Chevron, Plus/minus, and Caret.