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

Power BI User 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

Denise Hoban 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

Josh 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

Dave Ruijter on 05 Jul 2020 22:38:48

RE: Add Folders to organize fields

This idea is completed :).

's profile image Profile Picture

Hamish 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

Jon Fortner 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

Veena 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

Power BI Ideas Admin on 05 Jul 2020 22:20:06

RE: Add Folders to organize fields

Nothing more true then that ;)

's profile image Profile Picture

David Cox 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

Andy 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.