How to FLATTEN your Hierarchies / Get Reporting Lines and Direct Reports // Power BI Guide in 2022

[@tushargogiya4017]

Amazing content found when needed

[@argentexana]

Exactly what I was looking for!

[@letuan930]

Very helpful tutorial. Thank you for your sharing

[@khalid81320]

Amazing video. Am new to BI and learning every day a trick :) my question is How to show the total count of direct and indirect reportees ? Thank you so much

[@saikrishna2589]

Very helpful thank you

[@lajwanti3049]

I have built an organizational chart for my company with the visual Hierarchy Chart by Akvelon. Now i would like to filter for a specific team: basically, i would like (with a slicer or other solution) to start the tree at a lower point in the hierarchy.

[@heli1281]

Thank you so much for the informative video..I have one question please, I have a chart showing percentages of what people from different areas(cities)prefer to do in weekends, let's say 23% prefer to read books , but this percentage covers the whole country (different cities), how to show from that chart where are people who prefer to read with percentage/city? Thanks in advance

[@Ganiu-ff1sp]

Found this really useful, but how do you exclude the blanks without disturbing the data

[@raheem0046]

Thanks for your efforts Instead of creating Levels one by one can we split columns and rename them to Level 1 2 etc. If we can please share

[@ericet19]

As usual, incredible content. I’m working on a hierarchy for our company and both your hierarchy KZbin videos are very useful. So, useful I registered to Patreon to send you $. Not much but just to encourage you to keep up the good work. While I’m here on your first video showing how to fix the PATH errors. How could I automate this to make it bulletproof since we have a lot of movement on our hierarchy almost every week ? Thanks !

[@prabhatn]

HI Fernan, It was a great intro to learning the path in PBI. I have a situation where I want to show Employee Id, Name, Designation, Salary, Date Of Join and few other columns for Each Employee but 2nd level Employee should only be shown under the Manager Record and we can see when we hit the expand/+ symbol. Can you suggest?

[@archanacherukula1199]

Amazing video. What about the blanks at every level? If you have 10 levels the blank will also have 10 levels. please help me out here

[@srikanthkumar1358]

can some one paste the DAX code here in comments please .. i dont find it in Download links

[@srikanthkumar1358]

how to do the same in excel?

[@chennakesavareddyindukuri]

Hi, I need a help Employees Earning More Than Their Managers below the table data i need a dax Employee Id, Manager Id, Emp salary a b 100 b c 500 c d 250 d e 400 E f 5000 f