Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
RoomName | RoomID |
customer | 5 |
customer2 | 6 |
Customer3 | 7 |
Object | 2 |
Room1 | 13 |
Room2 | 12 |
Room3 | 11 |
Lab | 4 |
Room4 | 8 |
Room5 | 9 |
Room6 | 10 |
ROOMS | 1 |
Roomview | 3 |
Root | ROOT |
Table 2 is folder map
TreeNodeID | ParentNodeID | Name |
7 | 4 | Customer3 |
6 | 4 | customer2 |
5 | 4 | customer |
4 | ROOT | Lab |
2 | ROOT | Object |
1 | ROOT | ROOMS |
ROOT | - | Root |
Table 3 is object map
ParentNodeID | RoomID | Name |
6 | 12 | Room2 |
6 | 9 | Room5 |
7 | 11 | Room3 |
5 | 13 | Room1 |
7 | 3 | Room7 |
6 | 8 | Room4 |
5 | 10 | Room6 |
@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
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
@rtillery2000,
Please check modified PBIX file.
Regards,
Lydia
Close, when you select Lab it should show the Rooms under Customer, customer 2 and 3
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.
I have sadly made no progress on getting this to work
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |