Exactly what I needed help with, and much more! Thank you for explaining the necessity of each step. Many videos are watching someone simply type up some DAX which leaves this self-taught-during-free-time-Wannabe :) wondering "but why?". This video cleared up a few lingering questions as well as completely resolved my current need. Subscribing!
@PowerBIBro
2 ай бұрын
Wow I love this and thank you so much for sharing!!! I am so happy to hear the video cleared up questions and resolved your current need!!!
@Deepjoshi1986
12 күн бұрын
Amazing video, this is the exactly what i am looking for. Thankyou so much for the video and the way you explain is awesome 😊 Jut need 1 help how to handle if child is mapped to skip level directly Example: level 3 directly reporting to level 1
@PowerBIBro
11 күн бұрын
So happy to hear this is exactly what you are looking for! Appreciate your support and thank you for sharing! Here's my thoughts on your question. If a level 3 has a level 1 set as the parent then technically it is actually a level 2, so we'll need to update the data to force a break/space. It will require data manipulation, but to solve this, I would create a dummy record called 'level 2 empty' and have this roll up to the level 1, then I would change the level 2s (who need to be level threes) to be the child of this new dummy level 2 record. This should create the gap. I hope this helps, please let me know how you end up solving this one!!
@uygaride540
2 ай бұрын
Thank you for amazing video How can we do it when we add a new level? When I want to do this dynamically rather than statically, it gives an error. :/
@PowerBIBro
2 ай бұрын
Love the question and thank you for reaching out! For this process, you'll need to proactively build out empty layers for future growth. To my knowledge there isn't a dynamic way to do this using the methods via PATH functions creating columns. Let me know if you find something different!
@PeterMcPolin
Ай бұрын
Great vid! I have a problem though, I want to show text fields in my matrix. So when doing the step from min 30:00 onwards, I cannot format my measure correctly due to the conflicting data types. Is there a way to achieve this?
@PowerBIBro
Ай бұрын
Great question and thank you for asking. I’ll make a note to look into this
@melvanwyk1929
2 ай бұрын
When filtering the blanks out in the slicer it filters out some of the first level attributes as in my dataset some only has a parent and nothing more
@PowerBIBro
2 ай бұрын
Thanks for sharing this question! To help confirm your ask, are you stating that parents without children are not showing up? If so, that should not be happening. As an example, in the file provided, go to the tab [Hierarchy] and see the person 'Qa Dibivo' under 'Fufe Be', this person has no children but is showing up. Hopefully this helps, if I'm missing the question please let me know and I'll be happy to help!
@tinaflemons263
4 ай бұрын
Amazing, one of my favorite channels
@PowerBIBro
4 ай бұрын
This compliment just made my day!! Honored to be one of your favorite channels!!!
@bpsmurph
Ай бұрын
How would you handle an org structure that skips levels? Like if a manager reported directly to the CEO and didn't have a director over them.
@PowerBIBro
Ай бұрын
Thanks for your question! A role type of hierarchy (employee/manager/director/etc…) would have to be treated differently. In your example, taking the roles out, the manager is a direct report to CEO technically. The entire PATH function system is based on child/parent IDs, so you’d need to create your own new data set which has the manager linking to a blank director who then links to CEO. It’s all about the parent/child links in your dataset :)
@ClintonMcGregor
Ай бұрын
Thanks so much for this video, super helpful and detailed!! My dataset is from a filesystem and I am building reporting on the files within that system. The challenge is that there is currently 32 levels in the max depth and could be more next time its refreshed. Any alternative suggestions for dealing with such deep hierarchies?
@PowerBIBro
Ай бұрын
Thank you for sharing and I’m happy to hear you think the video is helpful and detailed! What a great question, 32 levels is huge! Offhand I’m not able to recall a method to dynamically create levels but I wouldn’t be surprised if one exists. I would probably go brute force and just manually build out a hierarchy 50+ levels to account for future growth and then be set. Thanks for our support and please share with others!
@sanchowitfurrows1561
3 күн бұрын
did you consider to flatten and pivot columns using Power Query?
@PowerBIBro
2 күн бұрын
@sanchowitfurrows1561 excellent question! The goal for this tutorial was to leverage the PATH functions specifically and I don’t believe those are available in power query. Please let me know if you have any power query transforming suggestions!
@felixvalembois9596
26 күн бұрын
Thank you for the tutorial however I have a question, Each time i hit the '+' button all my information just slides into the deepest level of my hierarchy and i have no information on my row, i tried multiple things but nothing worked so far. (some information just in case : I'm working on a database already flattened, hierarchy has been built thanks to column names, I foud a way to re-create the 2 mesures of depth like in the video and hide the blanks.)
@PowerBIBro
24 күн бұрын
Thanks for your question and I appreciate you sharing! These types of issues are typically associated with the steps performed at the point in which the hierarchy itself is created (right clicking and adding fields). It may be beneficial to go back and watch the below step, ensuring you add/build the layers in your hierarchy field utilizing the correct order as the order in which fields are added define the order in which they drill to. 18:46 - Create a hierarchy and create hierarchy measures
@tameshdoobay6058
4 ай бұрын
Amazing video. Question. The Data set i'm working with is a ragged multi-parent hierarchy. IE, One child can have multiple parents. As far as I know, the PATH function has issues in this regard. How can I overcome this?
@tameshdoobay6058
4 ай бұрын
I figured out a way around it! Amazing video!! Helps a lot.
@PowerBIBro
4 ай бұрын
Thanks for the update! I was looking into a solution for you, please share how you solved it and what the work around is. Interested to see how you solved it!!!
@tameshdoobay6058
4 ай бұрын
@@PowerBIBro I appreciate that you were looking into it!. I unfortunately had to compromise by turning it into a single parent hierarchy by making the children that belonged to multiple parents, unique. So, where they exist in multiple places, the dax formula would just append a "-" followed by a number starting from 1, continuing upwards for every occurrence of that ID. It's a cheap workaround but oh well :D
@PowerBIBro
4 ай бұрын
@tameshdoobay6058 genius and I love it
@arunwats
3 ай бұрын
Can you please share the solution/dax for this?
@nathanielmoss7470
4 ай бұрын
Great video, BRO!!! This has been extremely helpful. I'm working with a data set where parents have unique values from the children. How would you isolate the parent values from children without incorporating the children into the totals? I'm creating a chokepoint analysis tool that drills down from the strategic level to the direct level. 45:52
@PowerBIBro
4 ай бұрын
Thank you for this question and your support!!! I've been pondering your question and I'm not yet fully clear on your end goal, can you elaborate in a little more detail? Maybe provide some data examples if possible or an end goal mockup? If you like, you can email me additional details at powerbibro.rob@gmail.com and I'll be happy to look into it!!!
@nathanielmoss7470
4 ай бұрын
Thanks!
@PowerBIBro
4 ай бұрын
Wow thank you so much!!! This Super thanks is incredibly appreciated and I am so happy that the video is helpful!!!
@schilling3003
3 ай бұрын
This is great, but it requires that your number of levels does not increase, otherwise this breaks down.
@PowerBIBro
3 ай бұрын
Totally correct and thanks for sharing your thoughts! A best practice is to build beyond your current level structure. Essentially returning nulls as placeholders for future path levels.
@kasilvania
11 күн бұрын
Is there a way to have the level 01-08 pull multiple variables like name AND title so they both show up in the decomposition tree?
@PowerBIBro
11 күн бұрын
Love this question! Thank you for asking it and I appreciate your support! Yes, offhand this definitely seems possible and it will require some more advanced DAX manipulation. Essentially, if the goal is to return Name and Title in the same value, I would evolve the path functions to return both of these values independently, then concatenate them together as the result in what is being returned. I hope this helps point you in the correct direction, please let me know how you end up solving this one!
@AsadAli-tk4vw
3 ай бұрын
I watched this video from my other id where i was not signed up on youtube for a certain reason, so i am leaving a comment from this id, "Thank you! this video made my day", please make more videos like these which are ususally not available on internet with such explanation.
@PowerBIBro
3 ай бұрын
Awesome!! Thank you so much for sharing this great feedback and I'm excited to hear the video made your day!!!
@ExactitudeIT
24 күн бұрын
Hi Power BI Bro, Thank you very much for this great video. I actually got really far with my solution using your video. Thank you! I do have an issue with the blanks when I am using xViz Performance flow visual in Power BI. I am using it to create an organization hierarchy. It is such that if the lower level of the hierarchy has no value than the upper level will not get shown either. I.e. the highest level CLT has OPR and CIT as immediate child nodes. CIT has no further children. So when the hierarchy is extended till level 2 you do see CIT and OPR. But if the hierarchy is extended to 3, you only see OPR. I would like to keep seeing OPR. I do have an excel file with the structure and all the calculated columns done. If you kindly reply then I can showcase it. Thank you for your knowledge sharing! Best Regards Exactitude (Rehman)
@PowerBIBro
24 күн бұрын
Thank you for both the question and compliment, I'm happy to hear you found the video to be great! I appreciate the summarized description of the problem, unfortunately offhand I'm not deeply familiar with the xViz Performance Flow component. I'm unfortunately unsure how to solve your xViz issue without a deep dive.
@ExactitudeIT
23 күн бұрын
@@PowerBIBro I appreciate you getting back to me. I did get the issue resolved. Will it be ok if I link to the solution video from here?
@PowerBIBro
23 күн бұрын
@wajiharehman9011 that’ll be great!
@bpsmurph
2 ай бұрын
Amazing video. How would you go about creating a card based on the selected value of a leader in the hierarchy slicer since it selects multiple levels? I am looking to show information like the selected leader's job title and level. Also I noticed the actual leader doesn't show as their own row in the matrix. Is there a workaround to show them? For example, I'd like to show vacation hours accrued for leaders and their direct reports.
@PowerBIBro
2 ай бұрын
Thank you for the compliment and thank you for these questions! I'm happy to hear that you found the video helpful. Both your questions are great, and both are potentially complicated :) Offhand, I'll need to do some research into how to pull the desired results for both examples, but I love both use cases. In the meantime, please let me know if you find a solution!
@dcbelbiteam
4 ай бұрын
Outstanding video! Cannot wait to implement this! Soooo many use cases on our end! Thank you very much for this!
@PowerBIBro
4 ай бұрын
Awesome!!! Thank you for sharing and glad you love it!!
@tameshdoobay6058
4 ай бұрын
Question: around 33:05, you add the Sales to your values and use the same formula to eliminate blanks, which has worked for me. However, it seems the my numbers are affected, as it's counting blanks as well. I've read online to change the datatype to "Whole numbers" for that column, but it doesn't seem to help. Any solution?
@tameshdoobay6058
4 ай бұрын
Figured it out! Instead of using the DISTINCTCOUNTNOBLANKS for my numbers column (in my case, quantities), i used MIN, which for my case, returned the exact values without adding blanks.
@PowerBIBro
4 ай бұрын
Love how you're solving your problems so quickly!!! Great job!!!
@SmartBimson
4 ай бұрын
Super interesting 👍🏻 thank you very much for this video !
@PowerBIBro
4 ай бұрын
My pleasure and thank you!!
@artemkeller2571
2 ай бұрын
you saved my day! Thanks!
@PowerBIBro
2 ай бұрын
Awesome!! So happy the hear that the video was helpful!!!
@HappywithCath
4 ай бұрын
Nice!
@PowerBIBro
4 ай бұрын
Thank you!
@jaroslavplavec1937
3 ай бұрын
Thank you Teacher 👍
@PowerBIBro
3 ай бұрын
What a compliment!!! Thank you so much for sharing and happy to hear you loved it!
@VeganSmasher
4 ай бұрын
This is amazing, dude!
@PowerBIBro
4 ай бұрын
Glad you love it and thanks for sharing!!!
@douglascory
4 ай бұрын
Amazing video, thank you very much!
@PowerBIBro
4 ай бұрын
Thanks for sharing!!!
@douglascory
4 ай бұрын
@@PowerBIBro Maybe it is outside the scope of the video's subject, but I'd like to ask: How would one go about configuring e-mail accounts that are outside the sales hierarchy to still see all data? Would one have to add them to the path as a level above the highest? (Like a director that wants to see all data, but isn't on the sales hierarchy)
@PowerBIBro
4 ай бұрын
Totally applicable to this scenario and super easy to setup :) You'll want to another another role to RLS model, call it "See Everything" or whatever you prefer. For this role, we'll use it as a means to bypass the security hierarchy, in the Dax editor for this role simply put 1 = 1, or any expression that is always true. Then when you test this role, if you add a director to the permission of this role, they'll see everything and bypass the RLS hierarchy.
Пікірлер: 61