Forum Discussion
Resolver Islicer from a column with comma separated value
| number | customer name | hierachy code | url | engagement |
| 100 | aws | global customer | amazon.com | sales pipeline, regular |
| 1002 | amazon webservice | global customer | aws.amazon.com | sales pipeline |
| 1003 | wholes food market | www | complicated, sales pipeline | |
| 1004 | aws | global customer | amazon.com | amazon |
I have the above data, and I would like to have slicer for column "engagement". if "sales pipeline" is selected then first three rows are displayed, is that possib;e to do
to all if anyone wants to try, add the measure to filter panel and set to 1 . it works like charm
4 Replies
- amitchandak
Super User
sanjanarama , Not very clear to me. But Split column by delimiter into rows in power query can help
Split Column Power Query: https://youtu.be/FyO9Vmhcfag
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
sanjanaramaif I have a slicer on customer engagement , i see that all values in it are combined. I want to show slicer values as each of the catergory, without splitting up the data with delimitter, as all other column data are same.
- sanjanarama
amitchandak
https://community.powerbi.com/t5/Desktop/Once-Slicer-for-multiple-columns/m-p/407949
this post totally satisfy my requirement. But if I replicate same to matrix , it is not getting filtered,- sanjanarama
to all if anyone wants to try, add the measure to filter panel and set to 1 . it works like charm
