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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
pal95
Helper III
Helper III

Drilltrough-like functionality in Reports Builder

Hi, I would like to make something similar to drill trough in the reports builder. I have a parameters like:

ID
TIME
LOCATION
NAME

And I would like people to pick ID, and then Time, Location and Name should be updated automatically, so, for example:

ID = 1

Time: 10:59
Location: City
Name: A

And if someone pick another parameter, for example 2, I would like the report to show the values linked to ID = 2, so

ID = 2,

Time: 11:28
Location: Town
Name: B

I can't achieve it as if I put one main parameter (user can choose the relevant ID), and other internal parameters in the report, these internal parameters don't refresh when the user changes ID.

2 REPLIES 2
josef78
Memorable Member
Memorable Member

setup default value of secondary (hidden/internal) parameters (eg.town) based on first parameter (ID}

Greg_Deckler
Community Champion
Community Champion

@pal95 Not following this, can you post sample data? Screen shots? I am not able to visualize this what you want.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.