cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PBInath Regular Visitor
Regular Visitor

Sync hierarchy levels between two visuals with same dimension

Hey all,

 

I am looking for a functionality which is I believe not possible. However, you guys have sometimes surpized me with your ingenuity.

 

I have two column charts on one sheet which share the same dimension hierarchy: Business units > Categories > Products. Users have (obviously) the ability to drill down in hierarchy within a visual. I am in desperate need of a way to sync the level of hierarchy to which is drilled down to the other visual. 

 

If the user drills down on a particular business unit in visual A, I would like the visual B also to go down to this level. Currently, using the functionality "Drilling filters other visuals" will filter only the data in visual B to which has been drilled down in visual A. However, it will not go down in hierarchy level portrayed at the axis.

 

Can you think of a workaround? Any suggestion is helpful? Maybe an other (custom) visual which could lead to the same? Thanks in advance.

 

1 REPLY 1
Microsoft v-jiascu-msft
Microsoft

Re: Sync hierarchy levels between two visuals with same dimension

Hi @PBInath ,

 

I would suggest you create an idea here.

There could be an ugly workaround that is using a slicer to the change the X-axis. For example,

AxisInSlicer   ActualAxis

Year              2017

Year              2018

...                   ...

Month          Jan

Month          Feb

...                  ...

If you make a selection in the slicer, all the visuals in the pages could act.

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors