Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
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",
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.
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",
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
110 | |
109 | |
94 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
103 | |
86 |