Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I created hierarchy as Merchant and Product and enabled drill down from Merchant to Product level. If I drill down from Merchant to Hierarchy, Y - Axis, gives me names of both the levels (Merchant and Product) in the second level.
When I drill down to the second level I dont want to see Merchant (First Level) in Y -Axis. Which I highlighted in the second picture. Please do suggest any solutions. Thanks.
Solved! Go to Solution.
Hi @Kuberkk,
on the drill controls in the top corners click on "Go to the next level in the hierarchy" instead of "Expand all down one level in the hierarchy".
Regards
Chiara
I am still baffled. I understand clicking drill down button "go to next level" but I don't want to go to next level for all my Y-axis labels, only want to go to next level for horizontal bar that I click on. I have set up many of these horigzontal bar charts using hierarchies and this is first time I get the repeating upper level. Anyone have suggestion for drill down just on bar I click on? Thanks.
I'm noticing something weird (having the same problem) where If I double-click a bar to drill down - the hierarchy names carry over, but if i single-click, I get the desired result: just the child names.
Hi @Kuberkk,
on the drill controls in the top corners click on "Go to the next level in the hierarchy" instead of "Expand all down one level in the hierarchy".
Regards
Chiara
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |