Forum Discussion
aj451
3 years agoRegular Visitor
Slicer which works like contains text?
Hi all,
Is there a way to create a text slicer which searches a column in the data set to see if it contains the slicer values selected? For example, lets say I have the dataset:
| Name | Count |
| Cars | 2 |
| Trucks+Cars | 5 |
| Planes | 1 |
| Cars+Planes+Trucks | 4 |
I would like to create slicer buttons where if I selcet 'Cars' and 'Trucks' the reuslt would be the following:
| Name | Count |
| Trucks+Cars | 5 |
| Cars+Planes+Trucks | 4 |
1 Reply
- kaushalprashantRegular Visitor
Hello,
While searching for similar issue, saw this - Abstract Thesis 110: Power BI- Text Part slicer to filter/search text - YouTube, maybe would help. Full details here A slicer thats a smart text search? - Microsoft Power BI Community