Forum Discussion
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 split them out?
End goal, the selection will show any of the departments that have bene chosen.
IE slicer
Sales
Receiving
HR
HRSales
ReceivingSales
I did have to extract the values in the power query. current formula
= Table.TransformColumns(#"Extracted Date", {"DEPARTMENT", each Text.Combine(List.Transform(_, Text.From)), type text})ty
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
2 Replies
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.
