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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.