How to navigate to a column when I have hundreds of them

[LinhNguyen]

Hi,

I'm new to PowerBI and I have a dataset of over a hundred columns. I'm working in power query editor to edit data query before I move on to any further steps but it's so hard to scroll left/right to find the column I need.

Is there a search function or any thing else that can help me navigate to the column I need?

Thank you!

[TomMartens · Accepted solution]

Hey,

in Power Query you will find the ribbon "Go to column" in the "View" menu:

form here you can search the column you are looking for:

Hopfully this is what you are looking for.

Regards,

Tom

[LinhNguyen]

Thank you! It's exactly what I was looking for!

By the way, does PowerBI use keyboard shortcut? Is there a way I can open the 'go to coumn' window or other functions with a keyboard combination?I didn't see any suggestion when I hover my mouse over the ribbons so I suppose there's not, but I still wanna ask in case they have those shortcuts.