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
Joseph_Hchaime
Helper III
Helper III

Drill through from a cross-highlighted visual

Hi 

 

I have this scenario where on one page of a report I have two table visuals. 

 

When I click on one value of Visual A, Visual B gets cross-highlighted/filtered. 

 

However when I try to click on the filtered/cross highlighted value in Visual B to drill through from it, it won't let me. 

 

Can someone help me set it up? or is that feature not available? 

 

For instance: Table A has Sales by SalesPerson. Table B has Sales by City. 

 

I want to Click on the SalesPerson's name, then click on a specific City to drill through to details of sales for that specific person for that specifici city. 

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

Have you tried holding the control button before selecting visual B value?

That should work to drill down the information for the second visual.

Furtheremore, if you need to show aditional information ina other page you can also try with the drill throug capability of Power BI

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

View solution in original post

5 REPLIES 5
Syndicate_Admin
Administrator
Administrator

In the second screenshot drill thorug pane, you can see that company name is Riyahd filter is applied but not the responisble who should be Ziad el Khoury.

As you can see, the keep all filters option in the drill through menu is grey (not green as in the first screenshot). There is something locking the keep all filters option, may be an ambiguous filter context.

Syndicate_Admin
Administrator
Administrator

Can you show me some screenshots to undertand exactly what you need exaclty please?

Screenshot 1:

Screenshot 2023-09-04 145548.png
Screenshot 2:

Screenshot 2023-09-04 145539.png

 

it should only show me 6 clients and 8 #Matters

Joseph_Hchaime
Helper III
Helper III

Yes I did. It's not filtering out the records for that specific measure. It's giving me all the measures that are on the end view in the other page. Should it not filter them out since I clicked on only one measure in the source visual? 

Syndicate_Admin
Administrator
Administrator

Have you tried holding the control button before selecting visual B value?

That should work to drill down the information for the second visual.

Furtheremore, if you need to show aditional information ina other page you can also try with the drill throug capability of Power BI

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

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.