Different column format

[Harris0211]

Hi all,

I am very new to the Power BI world and would like someone to help me with my query.
I imported a SharePoint document library into PowerBi, which was very straightforward. However, a few columns have a different format, and I need help determining their value.

The Value shoes as  a list and when I click through it, at the end I can see the actual value, I was wonderign is there anyway I can see the value in the Power Query Editor insted of clicking a few times. Other columns value looks ok. The column that I am having issue is the lookup column.

[v-yaningy-msft]

Hi, @Harris0211 

Has your current problem been solved? If not, you can refer to @danextian reply and click on the expand button andexpand to new rows to fulfill your needs.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[danextian · Accepted solution]

Hi @Harris0211,

On the top right of the column, there is an expand icon which you can use  to either combine the elements of a list into a single text or expand  the elements into rows. If you want to access just the first element, create a custom column and enter this formula:

[Company Name]{0}

 That said, the second element is {1} as index in M starts with 0.