Add Folders to organize fields
Ability to organize fields into folders to allow users to easily find them
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:
Thanks again for all your support!
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.
Denise Hoban commented
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.
This would be a valuable feature when working with SQL-based data sources.
Dave Ruijter commented
This idea is completed :).
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.
Jon Fortner commented
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.
Nothing more true then that ;)
David Cox commented
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.
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.
Mat Grisham commented
In both Power BI Desktop and Web, it would be ideal to be able to utilize the SSAS Display Folders for both measures and attributes when connected to a tabular model. It would improve the user's experience when creating their own reports when the fields are organized in this manner.
Need the ability to group fields into sub folders. This is possible with SSAS multidimensional in Excel, but it is required in Power BI (web and desktop).
We are building a complex model with many measures and dimensions, and it is difficult finding fields in the very long list.