March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello All,
I have a SharePoint list that has two fields.
1-Project name (Single line of text)
2-Managers (Person or Group> Allow multiple selection>Yes)
I imported this into Power BI.
At power Query Editor:
Under the Manger column I see two list items as shown on the screenshot-1 below.
When I click on a list, I see 2 records as shown on the screenshot-2 below.
When I click on a record, I see all data that relevant to that record. Please see the attached screenshot-3
My question is this:
I want display those records’ (right now there are two records however there can be more than two records) value in a column like this:
Column:
title1, title2, title3 so on….
How can I achieve this?
Thank you for your support in advanced.
.
Solved! Go to Solution.
Hi @Dersim ,
instead of expanding the column, you can add a new column with this formula:
Text.Combine([Managers][title], ", ")
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
@Dersim I can never remember that one. @edhans @ImkeF
Hi @Dersim ,
instead of expanding the column, you can add a new column with this formula:
Text.Combine([Managers][title], ", ")
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
@Dersim What happens when you use the diverging arrows in the header of Managers, what options do you have?
Hello Greg Deckler,
We are almost there.
It gives me two options:
1-Expand to New Rows
2-Exract Values
The second option(Exract Values) gives error.
However, the first option gives me the list of values. Please see in the screen below.
When I chose the title valu which I am after. Then it works well but it creates extra rows for each value.
However, I want to have those values like this: Column : Manager.title-1, Manager.title-2, etc.
How can I get the data in this way?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
202 | |
137 | |
106 | |
70 | |
68 |