Forum Discussion
Comma separated string as single string in slicer
I have column where are strings separated by comma.
I would like to add those string as single values to slicer and be able to use it in a report.
I splitted this column delimited by comma to rows but the problem is that in one visual I need to use those strings separated by comma, not as single value.
So to sum this up:
- I have a column with string separated by comma
- I need those strings as single strings in slicer
- I need to show results as string separated by comma
What is the best way to do this?
1 Reply
Anonymous , Duplicate the column and split the new one.
Or create a new table with distinct of that column; and then split by a delimiter in the new table and join with the new table and old table using the comma-separated column. Make it bi-direction join
