Forum Discussion

Harris0211's avatar
Harris0211
New Member
2 years ago
Solved

Different column format

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...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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