Transforming unique values into their own columns

[Anonymous]

I'm working on building a Power BI, but running into an issue with one of the columns of data. I need to know how to transform a column of data that contains specific repeating values into their own columns. I have to make sure the rows of data tied to each value follow whenever I transform it.

Example: I need to have No Issue and Pick and Pack be their own columns. I'm needing to split them up so I can create pie charts, line graphs, etc. for each pick path without pulling in data for all pick paths at once. I'll be updating this daily, so splitting them into their own columns might not be the best option. Any suggestions would be much appreciated. 

 

[amitchandak]

@Anonymous , For pie you do need them as row values not column

The column you have to create new columns like

in power query

if [Pick Path] ="No Issue" then [Pick Path]

Unpivot does not seem like an option because of data

https://radacad.com/pivot-and-unpivot-with-power-bi