cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adm010
Microsoft
Microsoft

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?

1 ACCEPTED SOLUTION
AllisonKennedy
Super User
Super User

@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. 


Please @mention me in your reply if you want a response.

Check out my Tokyo 2020 report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

2 REPLIES 2
AllisonKennedy
Super User
Super User

@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. 


Please @mention me in your reply if you want a response.

Check out my Tokyo 2020 report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

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?

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors