Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
We are connecting to Dynamics 365 and - in several tables - we have multiselect pick lists. i.e. When we enter a contact we can select multiple values of the 'contact type' for a given contact - example in table below. John Smith is both a Salesperson and an Account Manager.
This contact field is displayed as a comma separated value in PBI table. How can we break this out to display as a separate table? We'd also want to have the contact name so can join back to main Contact table. (In reality would use key/ID fields instead of name - thisis just for the example).
Appreciate any help you can provide.
Thanks,
Dan
Solved! Go to Solution.
Split the 'Contact Type' column on ','
Select the 'Contact Name' and Address columns.
Go to the Transform Menu.
Select 'Unpivot-> Unpivot other columns'
Tidy up the data
Split the 'Contact Type' column on ','
Select the 'Contact Name' and Address columns.
Go to the Transform Menu.
Select 'Unpivot-> Unpivot other columns'
Tidy up the data
Thanks! That worked exactly as needed!
Greatly appreciate your assistance.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.