Forum Discussion

kurtsmetana's avatar
kurtsmetana
Frequent Visitor
5 years ago

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 ...
Need Help
VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
5 years ago

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's avatar
kurtsmetana
Frequent Visitor
5 years ago

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's avatar
    AG2
    Frequent Visitor
    3 years ago

    Did you end up figuring out the solution to this?