cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Slicer and Drill Down in a Chart

Hey,

 

I have a problem. I have one Chart with a hierarchy of Product Groups - it has 4 levels. I can easily drill down in the Chart by clicking on the axis. When I click on "Hauseigene Produkte", I get to the next level and see only the product groups of "Hauseigene Produkte". Now... I would like to add a slicer to my report which does the same thing. So my bosses dont have to click in that Chart but using the Slicer.

 

But if I use a normal slice (or the HiarchySlicer) the Chart only stays on one level without drilling down according to the slicer. So if I use the HierarchySlicer, the amounts on the Chart change, but not the axis. Even if I choose only some product Groups on the second and third level the axis only stays on the first level. See the picture...

 

What I would like, is that the axis changes according to the slicer -> if I slice on the first level the axis of the Chart only gives the first level. If I click on a deeper level I would love the axis to jump to that level, too.

 

Is there any solution for this?

 

Thank you so much in advance!

 

Sarah

 

 

slicer activated, but the axis remains showing first level product groupslicer activated, but the axis remains showing first level product group

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @SarahAlsterspre 

One workaround is to click on the icons of the bar chart:

"go to the next level in the hierarchy" or "expand all down one level in the hierarchy",

Capture3.JPG

Best Regards
Maggie

 

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

View solution in original post

1 REPLY 1
v-juanli-msft
Community Support
Community Support

Hi @SarahAlsterspre 

One workaround is to click on the icons of the bar chart:

"go to the next level in the hierarchy" or "expand all down one level in the hierarchy",

Capture3.JPG

Best Regards
Maggie

 

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

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors