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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
DebbieE
Community Champion
Community Champion

Drill Throughs showing more pages than I want (Or should be showing)

I have a line chart.

X Axis Year

Month (and I like to keep it at the lowest level so you can see all the months and years

 

Y Axis

Total people

 

Legend

Area

 

And I have an area Drill through Page

Drill through Filters

Year

Month

Area

 

And this is the one i want to go to which is in the drill though list

 

But I also have two other drill through pages. Set p the same but instead of Area I have a different attribute on each one.

 

And annoyingly they are in the list of drill throughs and I only want the one drill through page. i dont even understand why this is happening to be honest. if I selected one from the line chart there would be multiple values so It doesnt work

 

Has anyone got any ideas how I can make the drill through better?

1 ACCEPTED SOLUTION
PijushRoy
Super User
Super User

Hi @DebbieE 

In Drillthrough, please only keep Area and turn on Keep All Filter and check

PijushRoy_0-1709134683287.png

 


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

Hi @DebbieE ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
PijushRoy
Super User
Super User

Hi @DebbieE 

In Drillthrough, please only keep Area and turn on Keep All Filter and check

PijushRoy_0-1709134683287.png

 


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

that has sorted it, Thank you so much

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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