Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Thakshila
Frequent Visitor

Cannot expand the list values in side the column

‎11-28-2021 06:07 PM

Hi All,

 

I have an issue expanding the list values inside the power query. I'm not getting the two small arrows to expand the column as we usually do. any idea how to resolve it?

Thakshila_0-1638154584366.png

 

 

Thanks 

Labels:
Message 1 of 4
3,118 Views
0
1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User
In response to Thakshila

‎11-28-2021 07:18 PM

NewStep=Table.TransformColumns(PreviousStepName,{"Column1",each if _ is list then _ else {_}})

View solution in original post

Message 4 of 4
3,014 Views
0
3 REPLIES 3
KNP
Super User
Super User

‎11-28-2021 06:14 PM

Right click and choose, To Table...

KNP_0-1638152070400.png

You'll then be able to work with it.

 

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).		xOIEmaj

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
image		fabric-SUbadge
Proud to be a Super User!
Message 2 of 4
3,097 Views
0
Thakshila
Frequent Visitor
In response to KNP

‎11-28-2021 06:55 PM

Hi KNP,

That is the problem, When I convert it to the table. Still, I don't get an option to expand columns

Thakshila_0-1638154459821.png

Thanks

Message 3 of 4
3,037 Views
0
wdx223_Daniel
Super User
Super User
In response to Thakshila

‎11-28-2021 07:18 PM

NewStep=Table.TransformColumns(PreviousStepName,{"Column1",each if _ is list then _ else {_}})

Message 4 of 4
3,015 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All