Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
GAPER
Helper V
Helper V

Drill down a table

Is there a way I can drill down to the last level like Excel where we choose expand all? The issue with that is that we have to click so many times before we can see the data we want. (also hard to download before clicking multiple times

 

Thank you!

 

1 ACCEPTED SOLUTION
Uzi2019
Super User
Super User

Hi @GAPER 
You can just simply select this option to drill down all level as many level you have.

Uzi2019_0-1711105222427.png

 

every time when you click on double down arrow it open all the hierarchy by level by level.

 

I hope I answered your question!

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

View solution in original post

2 REPLIES 2
Uzi2019
Super User
Super User

Hi @GAPER 
You can just simply select this option to drill down all level as many level you have.

Uzi2019_0-1711105222427.png

 

every time when you click on double down arrow it open all the hierarchy by level by level.

 

I hope I answered your question!

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
miTutorials
Super User
Super User

In a Matrix you can right click and choose Expand > All

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.