Forum Discussion
Solved
Is it possible to represent a windows file and folder structure in a report?
Hi, I am trying to represent a folder and file structure in a report. I want to be able to expand and minimise the folders. Is this possible within PowerBI? I have been playing around with Ma...
I hope the information shared was helpful to you. If your question has been answered, kindly mark the most relevant reply as the Accepted Solution. This small action can make a big difference for others who are looking for the same solution.
Thank you for reaching out to the Microsoft Fabric Forum Community.
Please try below, For your reference, I’m attaching the .pbix file
- Add a column to distinguish between folders and files (e.g.,type="Folder" or "File")
- Combine both tables into a single table using Union in Power Query.
- Add Matrix to distinguish b/w Files and folders
If this information is helpful, please “Accept as solution” to assist other community members in resolving similar issues more efficiently.
Thank you.
I hope the information shared was helpful to you. If your question has been answered, kindly mark the most relevant reply as the Accepted Solution. This small action can make a big difference for others who are looking for the same solution.