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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
natasha519
Helper II
Helper II

Drill Down or Cross Report Filtering?

I have 2 different pages with visuals in the same Power BI file.  I would like to click on a point in a scatter chart in one page and make it filter another table on another page. Currently, if I hover over a point on the scatter plot it shows me the project number and project title.

 

natasha519_1-1654014994583.png

 

But I would like to click on the point and have it filter another table on another page that just has this project number and project title. Is this possible?

1 ACCEPTED SOLUTION

@natasha519 ,

you need to set one of the field of your source page as a drill through filter in target page like below.

Arul_0-1654020843557.png

then right click the visula you can see the drillthrough option to filter that particular data point in other page. Look at the highlighted one

Arul_1-1654020956213.png

Thanks,

Arul

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


View solution in original post

3 REPLIES 3
Arul
Super User
Super User

@natasha519 ,

you can try drillthrough option.

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


I am not seeing a drill through option in the scatter plot visual 

@natasha519 ,

you need to set one of the field of your source page as a drill through filter in target page like below.

Arul_0-1654020843557.png

then right click the visula you can see the drillthrough option to filter that particular data point in other page. Look at the highlighted one

Arul_1-1654020956213.png

Thanks,

Arul

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.