Working with the field list on a large model in Power BI Desktop can quickly make you end up with a lot of expanded tables and you collapsing them one by one.
Don’t do that
Even though that is good if you want to improve your chances of beating your kids in Fortnite – it probably won’t – so instead do one of the following
If you want to use your mouse
Click the show/hide pane in the header of the Fields panel
This will collapse all expanded tables in the field list at once – plus if you have used the search field – it will clear that as well.
But you want to do it using the keyboard use
ALT + SHIFT + 1
This will collapse all the expanded tables as well.
Here is a link to the documentation about short cut keys in Power BI desktop – run through them – there might be some that can save you a click or two
Keyboard shortcuts in Power BI Desktop – Power BI | Microsoft Docs
Pingback: Collapsing All Expanded Tables in Power BI – Curated SQL