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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Unknowncharacte
Helper II
Helper II

Drill Through Question

Hi, 
I created a report with two pages, on the main page, I have a list of cases

Unknowncharacte_0-1698414295659.png

When I click on a case, I am taken to another page, with case details, let's take A11 for example:

Unknowncharacte_1-1698414361939.png

 

My issue comes in when a case has more than 1 subject - A13, has 3 subjects. When I click on A13, "Detailed Case View" tab shows information for that specific subject rather than all 3. My initial solve was to concatenate subject names and complaints, so there is only 1 line for A13 but my solution was declined.

 

The user wants to keep the main page view as is, and when clicking on A13, "Detailed Case View" tab should show all the subjects in the case. Can someone help me achieve this?

 

Desired Outcome on Detailed Case View when clicking on A13

Unknowncharacte_0-1698415867939.png

 

Sample PBI:

Page Navigation.pbix

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

You need to use a shadow copy of your table and then use a measure to transfer the partial filter from the drillthrough to the shadow table.

 

 

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

You need to use a shadow copy of your table and then use a measure to transfer the partial filter from the drillthrough to the shadow table.

 

 

Thank you so much!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.