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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





that has sorted it, Thank you so much

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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