VISUALISE ORG CHARTS + Path, PathLength, PathContains, PathItem DAX Functions to EXPLORE Hierarchy

[@djaleleddineboussahel1501]

Thank you so much for your tutorial! It’s been incredibly helpful

[@nishahussain2580]

By any chance can we add pictures of the employees in the chart?

[@rupeshgoud2127]

could you please tell me whether we can highlight a single branch i.e., If we select John(UK Region Manager), all members under John should highlight.

[@SolutionsAbroad]

Hi, it sounds like you'll need to create a filter visual with the manager as your value. That way when you select "John" from the filter, it will filter anyone reporting the John. Hope that helps!

[@sksanket]

Hi there, Could you please suggest a trick to calculate the time difference in hh:mm ( Start Date 18/Sep/2021 10:14 , Complete Date 18/Sep/2021 10:18) looking for the difference between these dates ( as result) as 0:04 in a separate column, also want to bucketize the result as (1. 1.

[@SolutionsAbroad]

Hi there, you can try to use the DATEDIFF, to calculate the results, For grouping your results, you can use the SWITCH function here:kzbin.info/www/bejne/aJ7Xf36ZmdCVkJY I found a more elegant solution, which gives the same result, i will try to cover it in my future videos soon!

[@JoelNove]

Hello. Can the visual show 2 parents connected to 1 child? For example multiple owners for one entity. Thanks!

[@jeffrobinson1038]

This was an awesome explanation, thank you. I have been looking for a way to identify people in the organization who report up to a path to implement a dynamic row-level security model based on logged in user to see all the people within their path. I am going to explore this method using our AD to activate it.

[@ralphkaz]

How can I modify these DAX measures if my data table has monthly data? Meaning I have HR hierarchy data for each calendar month so the PATH expressions should only be looking at the records that correspond to the month for that row. In the visual I plan to have a dropdown to pick which month's data you want to view. Thanks!

[@ricordolee2326]

Is there a way to get only the direct children count number under each path in the graph instead of the cumulative count?

[@Rickyyyy15]

Hi can someone please let me know if the IDs have to be in whole number only? I have few text IDs like abc45, and they don't seem to be working with this visual. Please let me know.

[@sarojbharadwaj238]

Hi ,while i am trying to create this function got this error.Each value in 'E_AND_IP_BP1_MANAGER_V'[GPID] must have the same value in 'E_AND_IP_BP1_MANAGER_V'[MANAGER_GPID]. The value 'MA83OT66' has multiple values. Can you please help me on this..

[@ettimehra]

Please tell me how to create own bi account...

[@SolutionsAbroad]

Hi Etti, follow this guide here : kzbin.info/www/bejne/sIqunmuvd8qqh7c

[@lucasshipsides1510]

well explained, thank you!

[@powerbinareal]

Sempre incrível! #powerbinareal

[@suhamohammed9127]

Can you help me, I'm a programmer, but my manager asked me for a map that interacts with a filter search bar with drop down , and I don't know how to do it because I didn't know powerbi before. Can I communicate with you to explain the idea to you and make a video totorial of it?😭 Thank u for azure account again

[@GhostGERD]

Have you got the solution? BR

[@suhamohammed9127]

@@GhostGERD no , If u want help me I can send to u web on google like what I want by any social media acount u have