Forum Discussion
Solved
split out department from choice column
I have a multi choice column where users can enter all the departments that are important to their project. but, when made a slicer, it gives me entries of multiple departments as 1 item. How can I ...
Hi nerdyplayer ,
Consider adding delimiters when combining text:= Table.TransformColumns(#"Extracted Date", {"DEPARTMENT", each Text.Combine(List.Transform(_, Text.From),","), type text})Next you can split it by ",":
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly--How to provide sample data in the Power BI Forum--China Power BI User Group
thx, i was replacing values with comma and then delminating it but my method was not correct. Least it was on the same wavelength.