Add Folders to organize fields
Ability to organize fields into folders to allow users to easily find them
Toby Fulton commented
Please...!! seems crazy that the Query Editor has Groups in which objects can be organised, but the main Desktop doesn't!
Need this badly. Please provide an update on when Microsoft is planning to start working on this. Simple organizing of fields is pretty basic need. Tool like Power BI should support this.
Jesper Barslund commented
When will this be avaliable?
It's seems like it's already made, as it's a part of this video, showing a _Trip folder in the Trip table:
Been using the work around of creating a new tables to store measures in for over a year now, still surprised this hasn't been developed yet despite the various posts I have seen and the work already put into developing the selection pane etc?
Ali Hassn commented
The ability to organize data into folder and subfolder will make it easier for the business to locate objects
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.