Forum Discussion

adm010's avatar
adm010
Microsoft Employee
5 years ago
Solved

Separating CSV values generated by a picklist

Hi everyone.

 

Newbie question.  Have imported a load of data from Azure Devops.  Within Devops, there was a picklist to pick a number of apps used on each project.  When exported, these appear as eg Itunes; Excel; Games and so when you build a report, they come as one value rather than 3 to make a count on.  How can i get PowerBI to see these as distint comma seporated values, not a single value?

Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    adm010  If you're importing the data you can use Power Query to split the column. Click 'Transform Data' in the Home tab in the ribbon, then select 'Transform' tab in ribbon. Then Split Column. You can expand advanced and split into rows instead of columns too. 

     

    Does that help? Let me know if you need more info. 

2 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    5 years ago

    adm010  If you're importing the data you can use Power Query to split the column. Click 'Transform Data' in the Home tab in the ribbon, then select 'Transform' tab in ribbon. Then Split Column. You can expand advanced and split into rows instead of columns too. 

     

    Does that help? Let me know if you need more info. 

    • adm010's avatar
      adm010
      Microsoft Employee
      5 years ago

      Hey Allison,

       

      Thanks so much for taking the time to help me out 🙂

       

      Follow up if thats ok - So ive split the data into a couple of columns and now in my Fields tab can see column 1 and column 2.  What i need to do now is show both columns data in one combined chart - ie so i can see the number of each picklist item ive now seporated out.  I can create a chart to show one or the other, but not sure on how to combine them together?