cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Andrew17
Helper I
Helper I

Change the drilldown hierarchy level of multiple charts at the same time

Hi everyone,

 

I have a bunch of charts on one page, and they are measuring a bunch of metrics over time. My data is set up so I have a hierarchy of Date/Week/Month/Quarter/Year for each of those fields. I want to be able to have a filter I can click where I can change the x-axis from one of the levels of the hierarchy and have it change on all of the charts. Is this possible?

 

Thanks!

2 ACCEPTED SOLUTIONS
TomMartens
Super User II
Super User II

Hey @Andrew17 ,

 

this is not that easy as one might hope. I guess this video provides a solution, how you can achieve what you are looking for: https://www.youtube.com/watch?v=n-OWNaCUU0o

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

Perfect!


Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

3 REPLIES 3
TomMartens
Super User II
Super User II

Hey @Andrew17 ,

 

this is not that easy as one might hope. I guess this video provides a solution, how you can achieve what you are looking for: https://www.youtube.com/watch?v=n-OWNaCUU0o

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

I was able to do this using the info from the video you posted. Thanks so much!! It actually wasn't too hard.

Perfect!


Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Top Solution Authors