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

Drill-Down behavior with multiple hierarchies

Is there a way to create a chart with drilldown through multiple hierarchies?

 

We are trying to create a column chart where the shared axis has a drilldown through a time hierarchy (Year > Quarter > Month); this works, no problem.

 

However, the business user also wants to have a second hierarchy based on product (family code > product code > sku)

 

Using the two hierarchies, they could then report family code by year/quarter/month, or product code by year/quarter/month, or sku by family code > product > sku, all within the same chart.

 

Does this capability exist in any of the standard visuals?  Is anyone aware of a custom visual that might accomplish this?

2 REPLIES 2
Highlighted
Community Champion
Community Champion

Re: Drill-Down behavior with multiple hierarchies

@SteveNak

 

Hi, don't know if a chart can do that,

 

 

But you can recreate the scenario :

 

-Using 2 charts.

&

Using bookmarks and Selection Pane to hide or unhide  one of this.

 

 

Regards

 

Victor

Lima - Peru




Lima - Peru
Highlighted
Regular Visitor

Re: Drill-Down behavior with multiple hierarchies

@Vvelarde

 

Hello Victor,

 

Thanks for the response.  It does appear that this may meet the user requirement; we are going to build the chart using this approach and will show it to them.

 

One thing I did notice during a test is that when a user opens the report via an app, the view bookmarks option is not selected by default.  Do you know if there is a way to do this?

 

Regards,

 

Steve

Steve

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors