Skip to main content

Power BI

Completed

Add Folders to organize fields

Vote (531) Share
's profile image

on 08 Dec 2015 00:45:55

Ability to organize fields into folders to allow users to easily find them

Administrator on 27 Dec 2019 03:41:15

You're able to set these in the Model View properties pane. I see some comments asking for the ability to put *tables* inside display folders. Please add your votes here to support that: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38593990--display-folders-above-table-level-in-data-model Thanks again for all your support!

Comments (32)
's profile image Profile Picture

656634fd 4c31-4a62-bdb3-e8298d360ec4 on 05 Jul 2020 23:08:11

RE: Add Folders to organize fields

Move up or down the display folders in the Fields list explorer.
I have created display folders in SSAS Tab but when in the PowerBI Desktop, these display folders appear random in the middle of the list of items for this table: I would like to be able to place the display folder where i want, i.e. at the top or at the bottom of the fields list or wherever I want. Note that I I use Excel to browse the cube I see the Display folder at the end of the item list which is OK.

's profile image Profile Picture

2a92c210 600f-4710-b740-b0f42ca81ab5 on 05 Jul 2020 23:06:01

RE: Add Folders to organize fields

The ability to group fields together. Not Values in a field and not hierarchical fields, but the fields themselves when they are 'like' objects. For example, I have many yes/no fields that are demographic descriptors (such as socio-economic status). I want to be able to group all of these like fields in a folder together, so I don't have to hunt to find the field in the field list.

's profile image Profile Picture

a464b778 76d5-4977-a861-d64318217435 on 05 Jul 2020 22:42:23

RE: Add Folders to organize fields

This would be a valuable feature when working with SQL-based data sources.

's profile image Profile Picture

b9499e29 98ce-4883-aabc-8795c32a2174 on 05 Jul 2020 22:38:48

RE: Add Folders to organize fields

This idea is completed :).

's profile image Profile Picture

db6ac723 ed7a-4f18-9144-5d79a36e351c on 05 Jul 2020 22:31:28

RE: Add Folders to organize fields

We have models with large numbers (100+) of fields & measures; which can make it cumbersome to navigate and find the desired field or measure. The ability to group them into a folder structure would make it much simpler to use. This should include the ability to have some fields from one table in one folder, and other fields from the same table in another folder.

As a workaround, we have created a pseudo folder structure by splitting what should be single tables into multiple tables with relationships, and created dummy tables for measures, but obviously this is not ideal.

's profile image Profile Picture

23829ea9 271b-49ff-b7e1-df50fed2b62d on 05 Jul 2020 22:21:37

RE: Add Folders to organize fields

I agree. As a work-around, you could create separate Data Sources being sure to include the key/join fields for merging. Business Objects uses Class folders and Subfolders to organizes the fields into.

's profile image Profile Picture

a5980771 6ced-4877-9a14-ca6d549e63e1 on 05 Jul 2020 22:21:35

RE: Add Folders to organize fields

Add your votes here
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6921269-grouping-fields-into-dimensions-and-measure

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:20:06

RE: Add Folders to organize fields

Nothing more true then that ;)

's profile image Profile Picture

77f8a410 40e9-4be4-adc3-d9f51666d01d on 05 Jul 2020 22:20:06

RE: Add Folders to organize fields

We have models with large numbers of tables and attributes - search helps but grouping in to folders would make things much easier for end users. Also the ability to order attributes other than alphabetically would be great.

's profile image Profile Picture

dfd5263a 806d-4dcc-a6f0-643e90aa0d5f on 05 Jul 2020 22:19:59

RE: Add Folders to organize fields

In 2016 CTP 3.3 SSAS Tabular can now have display folders. I've been using BIDS helper to do something similar. It would be ideal if PowerBI desktop and PowerBI could show these folders in the UI.