cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zuerichris
Helper II
Helper II

Perform additional steps depending on a value / variable

Hi all

 

I have a tricky task. I am building a hierarchy based on a parent/child table. Unfortunately, I do not know how many levels the hierarchy will have. And even worse, it's subject to change from time to time.

 

So what I would like to do is query the parent/child table as long as necessary. E.g. if I find out that in level 3 there will not be any more children, the next steps should not be performed.

 

Is that possible?

 

How?

 

Thanks

 

Christian

4 REPLIES 4
v-deddai1-msft
Community Support
Community Support

Hi @zuerichris ,

 

Based on my understanding, you want to limit users to see their own data and the users have a hierarchy, am I right?

 

I would you suggest you use dynamic rls by organization hierarchy: https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

 

I think this is still not what I am looking for. Forget about the hierarchy options.

 

This is more about performing additional steps when querying the data. And about performing steps depending on a given value.

zuerichris
Helper II
Helper II

Hi

 

I am sorry, that does not help. What I want to do is perform additional steps in the data source gathering depending on informations from that data source.

 

Simple example: 

I am getting data from a source which is a list of all bosses. I then want do see their direct reports. And for them, again the direct reports. And this should be done as long as there are direct reports.

The reason why the classical hierarchy does not work is that there might be direct reports with more than 1 boss and the hierarchy does not come in columns, but in rows...

 

Hope this is more clear now.

v-deddai1-msft
Community Support
Community Support

Hi @zuerichris ,

 

I'm not getting clear from your requirement. But in model view, you can create hierarchy easily.

 

Capture.PNG

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!