Power BI - Show Multiselect Column Values in 1 Row!

Todays video is a follow up on a previous video of mine where I showcase how to show People Picker columns from SharePoint lists in Power BI. This time we show not only People Picker but also multiselect Choice Columns and we spice it up by showcasing all values inside a single row, to eliminate the creation of duplicates. Here is the code for expanding the table row from the People Picker column: .... #"Extract_List" = Table.TransformColumns(#"Removed Columns", {"Content.People", each Text.Combine(List.Transform(Table.TransformRows(_,each [FirstName] & " " & [LastName]), Text.From), ", "), type text}) in #"Extract_List" Here is the code for expanding the table row from the multiselect Choice Column: ... #"Extract_List" = Table.TransformColumns(#"Removed Columns", {"Content.Color", each Text.Combine(List.Transform(Table.TransformRows(_,each [Value]), Text.From), ","), type text}) in #"Extract_List" If you want to learn more about Power BI, you are welcome to follow the channel and subscribe to the Power BI playlist here:    • Power Automate & SharePoint Online - English   Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj Buy me a pizza 🍕- https://bmc.link/enealicaj