Forum Discussion
Get Chart to Display Information One Level Below Chosen Hierarchy
Hello could use some help here!
I have a standard organization hierarchy slicer.
When users select their organization, I'd like the charts to display the level below them on the X axis.
For example, look at this basic organization table:
| Level1 | Level2 | Level3 |
| Region1 | Area1 | District1 |
| Region1 | Area1 | District2 |
| Region2 | Area3 | District3 |
When the user navigates through the slicer and chooses "Area1" I'd like a waterfall chart to show his districts on the X axis (District 1 and 2).
Basically a chart that is looking at a step down from the chosen organization column.
Any ideas??
3 Replies
- VijayP
Community Champion
Create A list of areas as a separate Table
Using SELECTEDVALUE Function create a selection criteria and use that in Switch Function to invoke the values based on Slicer Selection .For Better understanding Watch this video from 7:20 onwards
https://youtu.be/_U2M0Hkotl4?list=PLWQB3PEUJKRneu8fam5CaCMCdrIdT_zDD
Let me know it is helpful or any further help required!
Hello I am aware of selectedvalue / switch functionality. However, it is not that simle, we have a large organization. The above was just a very basic example. Our structure goes from
Region -> Area -> District -> Branch
A user could choose any one of these.
Goal is to display the next level down based on their choice. Using the SELECTEDVALUE method as you describe.... the slicer would be flat and contain all organization levels, which isn't the optimal user experience...
Did you end up figuring out the solution to this?
