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

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ก.ย. 2024

ความคิดเห็น • 17

  • @Rickyyyy15
    @Rickyyyy15 6 วันที่ผ่านมา

    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.

  • @rupeshgoud2127
    @rupeshgoud2127 2 ปีที่แล้ว +2

    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
      @SolutionsAbroad  2 ปีที่แล้ว

      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!

  • @suhamohammed9127
    @suhamohammed9127 2 ปีที่แล้ว +1

    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
      @GhostGERD 2 ปีที่แล้ว

      Have you got the solution? BR

    • @suhamohammed9127
      @suhamohammed9127 2 ปีที่แล้ว

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

  • @sarojbharadwaj238
    @sarojbharadwaj238 2 ปีที่แล้ว

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

  • @JoelNove
    @JoelNove ปีที่แล้ว

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

  • @ettimehra
    @ettimehra 3 ปีที่แล้ว +1

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

    • @SolutionsAbroad
      @SolutionsAbroad  2 ปีที่แล้ว

      Hi Etti, follow this guide here : th-cam.com/video/zYKm8yBewQU/w-d-xo.html

  • @ralphkaz
    @ralphkaz 2 ปีที่แล้ว

    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!

  • @jeffrobinson1038
    @jeffrobinson1038 2 ปีที่แล้ว

    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.

  • @ricordolee2326
    @ricordolee2326 2 ปีที่แล้ว

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

  • @powerbinareal
    @powerbinareal 2 หลายเดือนก่อน

    Sempre incrível! #powerbinareal

  • @sksanket
    @sksanket 3 ปีที่แล้ว

    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
      @SolutionsAbroad  2 ปีที่แล้ว +1

      Hi there, you can try to use the DATEDIFF, to calculate the results,
      For grouping your results, you can use the SWITCH function here:th-cam.com/video/2mtNKcdkbZ4/w-d-xo.html
      I found a more elegant solution, which gives the same result, i will try to cover it in my future videos soon!

  • @lucasshipsides1510
    @lucasshipsides1510 2 ปีที่แล้ว

    well explained, thank you!