Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
adm010
Employee
Employee

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.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

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.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.