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
bi_ppl
New Member

Drill through on two columns to another page

Hello Folks, 

 

I am trying to drill through on either of the two columns (Origin ID, DestinationID) on page1 to page 2 (ID). The data looks like below

 

Page 1

bi_ppl_0-1676505015545.png

Page 2

bi_ppl_1-1676500833356.png

 

Because only 1 active relationship is allowed, I am not sure how to model the relationship for the drill through, or what kind of additional table I should create to enable thedrill through. Any help would be appreicated, thank you!

 

2 REPLIES 2
olgad
Super User
Super User

Did you add origin id and destination id to your drill through page to the drill through fields?


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Yes, I added both origin id and destination id to the drill through fileds

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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