DAX hierarchy question

[dhbhojwa]

We have a requirement where when the user logs into powerBi he should be able to see all his direct reportees and indirect reportees based on the slicer.

So there will be a slicer having two options. 1st option will be direct reportees and 2. indirect reportees.

By clicking the 1st option the user should be able to see all the direct reportees and by clicking on th 2nd option he should be able to see all the indirect reportees.

The SQL table has two columns, having the childId and parentId.

There will be multiple user like this who logs in and they should be able to see there direct and indirect reportees.

Is this scenario possible using the powerBi ? 

Need help. 

Thanks in advance.

[v-jiascu-msft]

Hi @dhbhojwa,

Can you share a sample of you data? Did the slicer and a table visual work?

Best Regards,

Dale