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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
rickferreiran
Helper I
Helper I

Show only the drill through to different pages based on data hierarchy

Hello I have a measure A and a line chart with data hierarchy on XX axis. 
I have two hidden pages one for month and another for year details.
My goal is, when on the xx axis I have the year I would like only see the year detail page:

rickferreiran_0-1731682711339.png

when on the xx axis I have the month I would like only see the month detail page 

rickferreiran_2-1731682782738.png

 


Is there any way to configure that?

 

1 ACCEPTED SOLUTION

If you left click on the dot INSTEAD of right clicking this causes a filter.

You can use this filter on a button to change its drillthrough filter and destination.

For example if the filtered generated is by month go to the month page and if the filter is year then go to a year page etc


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

View solution in original post

6 REPLIES 6
SamWiseOwl
Super User
Super User

Hi @rickferreiran 

If those two are the only destinations have you considered a drillthrough button?

The destination can be set on an expression.

SamWiseOwl_0-1731683912320.png

 


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

This is not a botton but when I click on graph on the dot inside the graph.

Your solution does not work for my case.

Them clicking on the dot filters the button.

Yes it is adding an extra step but achieves the outcome.


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

Sorry, I did not understand your comment. My drill through is when I click on dot in the graph:

rickferreiran_0-1731685875882.png

 



If you left click on the dot INSTEAD of right clicking this causes a filter.

You can use this filter on a button to change its drillthrough filter and destination.

For example if the filtered generated is by month go to the month page and if the filter is year then go to a year page etc


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

Thanks, but I do not understant your solution.

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors