Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Which visual to use, to show PATH Calculated column values?

Hello All,

 

Currently, By using PATH function, we can get each employees hierarchy i.e how a employee connected in his organization.

 

But to use this calculate column and show in a graph manner that who is his upper level hierarchy and who is his lower level hierarchy, then which visual is better to use.

 

Any help,

 

Mohan V

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Anonymous,

     

    >>But to use this calculate column and show in a graph manner that who is his upper level hierarchy and who is his lower level hierarchy, then which visual is better to use.

    Current power bi not contains visuals who can direct recognize the calculated column which analysis by path function.

     

    I'd like to suggest you use path function to analysis the hierarchy structure and create custom hierarchy based on it.
    Then use this hierarchy column as axis to analysis your data.

     

    Reference links:

    Creating a Hierarchy in Power BI

    Creating a user hierarchy from a manager column to use as hierarchy slicer

     

    Regards,

    Xiaoxin Sheng