Tabular Display Folders

Unlike Multidimensional projects, Tabular projects in SQL 2012 do not support display folders. This feature gap makes Tabular models less user-friendly since the field list in Excel PivotTables is longer and less organized than it could be.

Warning: While display folders work in Tabular models, they are not officially supported by Microsoft. If you encounter a bug in how Tabular handles display folders and open a support case, Microsoft may not provide support.

BIDS Helper provides a UI for editing display folders on measures, columns, and hierarchies. All display folders are edited in the same place. Right click on the .bim file and choose Tabular Display Folders...

TabularDisplayFoldersMenu.png

That launches the UI for editing display folders:

TabularDisplayFolders.png

Tips:
  • If a field is showing up under the "More fields" folder in the Excel field list, setting the display folder to a backslash (i.e. \ ) will cause it to show up under the root of the table, not under the "More fields" folder.
  • Some client tools like Excel allow a field to show under multiple folders. In order to accomplish this, separate the two folders with a semicolon (i.e. Folder1\SubFolder1;Folder2)


Limitations:
  • Note that some changes like reordering levels or setting format strings will wipe out the display folders. BIDS Helper backs up the display folders in an annotation on the database. That way, the Tabular Pre-Build feature can prompt you to fix this setting.
  • Display folders are not supported in all DAX clients
    • Power View for Sharpoint will show display folders if you have SQL 2012 SP1 CU4 or later installed
    • Power View in Excel 2013 currently ignores display folders (all measures are displayed in a flat list)
  • Display folders are not supported on Tabular KPIs currently due to a bug in Analysis Services.


After changing display folders, BIDS Helper may prompt you for the credentials to a data source which is using stored credentials if you have not already entered those credentials during this SSDT editing session. This prompt ensures that data source credentials in the workspace database do not get wiped out as display folder settings are applied.

Last edited Jun 28, 2013 at 4:07 AM by dgosbell, version 8

Comments

furmangg Nov 22, 2013 at 3:13 PM 
I don't think there's a way to set a display folder to make it show in another table. The only way to sort of accomplish this is:
1. Use calculated columns to pull columns from DimProductCategory into DimProduct, then hide DimProductCategory. Then you can assign a folder to the columns in DimProduct.
2. Use a measure in table a to summarize table b. Then you can put it in a folder in table a.

Gooders Nov 22, 2013 at 10:08 AM 
Is there a way to put fields from different tables into the same display folder?