cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rtillery2000 Frequent Visitor
Frequent Visitor

power bi: Folder structure downward lookups

I have a folder structure that leads to end results of an object

I can get a lookup going by picking the folder above the object but I can not seem to figure out how to still see the object below when I go two or more folders up.

I have three table to pull this information from. And this needs to be dynamic enough that if another folder layer was added it I would have to make changes.

Think of structure like this:

Top folder

    folder

    folder

        folder

            object

    folder

 

Table 1 is all folders, objects, and its  associated ID

RoomNameRoomID
customer5
customer26
Customer37
Object2
Room113
Room212
Room311
Lab4
Room48
Room59
Room610
ROOMS1
Roomview3
RootROOT

 

 

Table 2 is folder map

TreeNodeIDParentNodeIDName
74Customer3
64customer2
54customer
4ROOTLab
2ROOTObject
1ROOTROOMS
ROOT-Root

 

 

Table 3 is object map

 

ParentNodeIDRoomIDName
612Room2
69Room5
711Room3
513Room1
73Room7
68Room4
510Room6
6 REPLIES 6
Moderator v-yuezhe-msft
Moderator

Re: power bi: Folder structure downward lookups

@rtillery2000,

Pleae check if the following PBIX file returns your expected result. If not, please share your desired result.

https://1drv.ms/u/s!AhsotbnGu1NolA1QhPgT1WM-Wp_e

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rtillery2000 Frequent Visitor
Frequent Visitor

Re: power bi: Folder structure downward lookups

Thanks,

The goal is if you select a higher folder it will show all the rooms in lower folders.

mod the file you made, if you select customer2 the rooms are shown, the goal is to select a folder level higher like lab and shows all rooms in folders below it.

 

https://1drv.ms/u/s!Ahv5U88PMQayhA3-n8Sz1TpU4bdu

 

Moderator v-yuezhe-msft
Moderator

Re: power bi: Folder structure downward lookups

@rtillery2000,

Please check modified PBIX file.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rtillery2000 Frequent Visitor
Frequent Visitor

Re: power bi: Folder structure downward lookups

Close, when you select Lab it should show the Rooms under Customer, customer 2 and 3

 

rtillery2000 Frequent Visitor
Frequent Visitor

Re: power bi: Folder structure downward lookups

so this is close to working but still not what I am wanting

 

https://1drv.ms/u/s!Ahv5U88PMQayhA-S1jnsZbQ_qEy7

 

 

should be only 2 tables, one with folder structure and one table showing all rooms possible under that folder. (note folders are called nodes for type)

Example if looking at file click lab and the 3rd table shows all the rooms, but if you go up one level to Root it doesn't, I would have to add a 4 table as it stands currently to make that work. this is not dynamic. Kinda need like a feedback relationship

 

Any help would be greatly appreciated.

rtillery2000 Frequent Visitor
Frequent Visitor

Re: power bi: Folder structure downward lookups

I have sadly made no progress on getting this to work