Get Chart to Display Information One Level Below Chosen Hierarchy

[kurtsmetana]

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??

[VijayP]

@kurtsmetana 

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!

[kurtsmetana]

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...  

[AG2]

Did you end up figuring out the solution to this?