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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors