How can I format a Table vaue in a column

[ItsProtosup]

Hi everyone, i'm working with a new dataset and I just see many columns contains "Table" values. I know theses columns values because this dataset is a sharepoint list.

So, values are are choose by a choices dropdown list directly in sharepoint.

My problem : I explore a little the Power query features but when I modify the column query I can see one row per choice list selection. How can I have all selected items of the sharepoint list choice dropdown list in ONE power bi cell ? 

Please see this example when I modify the column query i have a lot of duplications

My goal is to have a line with Durée = 0 with Opération = Controle-OR & Controle-IR

Or

Durée = 6.8 and Opération = Controle-OR & Controle-IR & Controle-Rlt & Montage

Thanks in advance for your precious help  !

[christinepayton]

It's because your lookup should be another dimension in your data model. When you have any multi-value field, you'll typically have two tables and relate them 1:many - that's why on the SharePoint end you have two lists, too - it's just dynamically showing the lookup values for you. 

You can do the same thing in Power BI, where you have two tables and show concatenated values in your main table but the data itself actually "lives" in a separate table. I did a tutorial on how to set this up with SharePoint lists here if it helps - conceptually you do the exact same thing for multivalue person columns too because the person values are a lookup to a user profiles table on the back end essentially. Mentioning this because I think the tutorial example is with multivalue people but the concept is the same. 

[ItsProtosup]

Hello @christinepayton , 
I see ur vidéo and I'm not sure to iunderstand your process.
In my SP list y have the same column type as your "Request status" column but mine can contain multiple choices, that the main problème. How can I retrieve all the selected choices and display them in un cell and int a single row...

Thank you for your advices !

[christinepayton]

There's a bookmark for dealing with multivalue fields in the video, here is a link to the spot. I think I used a people column but the concept is the same for choice: https://www.youtube.com/watch?v=LYu3wqb2Nx4&t=525s

[amitchandak]

@ItsProtosup , One way it expands the tables. Second, you perform all operations treating that value column, in the transform column.

Can you share sample data and sample output in table format?

[ItsProtosup]

Hi @amitchandak, Does my screenshots int my first topic post corresponds as you are looking for ? 
If no, can you explain more specifically what do you want ? 

Many thanks for all your advices 🙏