split out department from choice column

[nerdyplayer]

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

[nerdyplayer]

thx, i was replacing values with comma and then delminating it but my method was not correct. Least it was on the same wavelength. 

[Anonymous · Accepted solution]

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 Team

If 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