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
Dellis81
Continued Contributor
Continued Contributor

DrillThru Select single point vs all?

Hello

 

I am really struggling with drill thru navigation and have tried several things.

I do have drill thru working,  but want to go an additional step and create conditional navigation based on what is selected.  I have a button setup - and the conditional measures are returning the correct result.

My challenge, users would like to select an item within the matrix dimension (Air Seeder) - and conditional drill thru action takes them to a multi year report.   The normal drill thru process works, if the user hovers over a value within the Totals column (ie $15,762).   The user unfriendliness is caused by the "Total column' often being hidden (exceeds size of matrix alloted space)

Currently when the airseeder item is solely selected (in yellow), the button tooltip indicates a single point be selected.

When a single value is selected, my conditional measures are working - and drill thru takes me to desired page.   It's when I want to select all years, but not scroll clear over to the total column.

 

Are there workarounds or video/blogs that may help in this?

thank you!

 

MultiPointDT.PNG

2 REPLIES 2
v-yanjiang-msft
Community Support
Community Support

Hi @Dellis81 ,

I'm not quite clear how can you achieve drill through only when hover over the total value. By my test, when we put segment column in the drill through fields, once hover over any value of segment column we can click drill through.

vyanjiangmsft_0-1683711168419.png

 

Best regards,

Community Support Team_yanjiang

Hello.  My hope was to select the "AirSeeder" segment column and that would allow drill thru to ALL years.   Drill thru does work if an individual point is selected or if total column value is selected ALL years are included.

 

I was hoping to avoid the user from having to go mouse over to the Total column, was hoping process could be simplifed if AirSeeder within Segment column was selected.

 

Been doing more research on this - and not sure this is doable, other than a web url...  Which takes you to a completely new window and adds navigation confusion to the user.

 

thank you!

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.