Forum Discussion
Hierarchy in scatter chart for a drill down view
Hi I am creating a scatter chart like below-
And I have to enable drill down in this visual. I want "Country" level information to appear when I try to drill down the visual and "Region" level when I drill up.
However, I am not getting the option to have the heirarchy at 'Legend'
How this can be resolved?
Thanks in Advance!
2 Replies
- Kishore_KVN
Solution Sage
Hello rohit1992 , First you have to add that hierarchy to X axis not to legends. No need to create any new hierarchy you can just drag Region first in the X axis and in the same X axis below region drop Country column as well. Then you will get the drill down and drill up options.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
In Scatter chart, I cannot select non-numerical value for the x-axis.
