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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
jsha
Frequent Visitor

Add a drillthrough directly to the last level in the hierarchy? Without user having to right click

Hello.

When working with a matrix; is it possible to add a drillthrough directly to the last level in the hierarchy? Without user having to right click, select drillthrough and select the drillthrough field. Something like this: Drill down --> drill down --> drillthrough (three left-clicks) Or are there any other 'methods' in order to achieve a smooth GUI with few mouse-clicks? (Enable +/- icons in Row headers? Use drill down combined with tooltip?)

 

-jens

2 REPLIES 2
amitchandak
Super User
Super User

@jsha , I doubt that is possible, You can create an idea - https://ideas.powerbi.com/ideas/

I have a matrix with four hierarchy levels, in addition there is one drillthrough level:

(1) Phase - hierarchy

(2) Building Block - hierarchy

(3) Discipline - hierarchy

(4) Activity - hierarchy

---

(5) Documents - drill through

 

As per now the end user has to know about (1) drill down arrow and (2) right-click drill through. And then there is 5 'operations' to get down to the documents: 

 

(a) Find and click Drill down arrow on top of matrix

(b) Click on phase (level 1)

(c) Click on building block (level 2)

(d) Click on discipline (level 3)

(e) Right-click on activity (level 4), Select Drill through, select 'Docs'

 

The challenge is that not all users are aware of the drill down and drillthrough. The intuitive user behaviour is to click in the matrix and then see what happens.

 

Any tips on how to improve the GUI here? 

 

Or, any other methods than matrix/drill down/drill through to consider?

 

-jens

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.