Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Organizing Measures into Categories using Folders

Adding few measures to your data model in PowerBI could be easily managed, but what about adding tens or even hundreds of measures! Organizing those measure into categories using folders could help a lot. To show you what I exactly mean, I will demonstrate the alternative way to create those folders using empty tables: 1. Select "Enter Data" from the Home ribbon > Change the column name to "Id" and choose the table name e.g. "_Financial Measures" (Create all the tables) 2. Select "New Measure" from the Modeling ribbon (Or choose any shortcut) > Type and create a new measure e.g. Total Sales = SUM(Sales[SalesAmount]) 3. Select the created measure in the "FIELDS" pane or just click inside the formula bar > Open the "Home Table" list from the modeling ribbon and select a table 4. When done, right-click on the "Id" columns and select Hide 5. Now, Power BI will change the Icon from Table to Measures. How nice! Happy PowerBI-ing,
Status: Completed
Comments
ryan_vincent
New Member
We definitely need a way to group these without resorting to clumsy annoying to read names and hacky tables. This would be a great QoL upgrade.
Andrew_Goldman
New Member
Certainly a nice to have so +1 vote, but not my highest need relative to other voted items
fbcideas_migusr
New Member
Would be great to Catgorize & filter/search without moving into different folders! E.g. Categorize by Scenario: "Forecast" vs. " Actual" vs. "Budget" Categorize by Calc type: "Trailing-Twelve-Month" vs. "Year-to-Date" vs. "Prior Month, Year etc"
jeroen7
New Member
Already possible, create display folders. I have submitted this idea to be marked as completed.
nishalit
New Member

Display folders provide this capability.

FI6T
New Member
The display folders are super nice 👌

A great addition would be to the ability to drag and drop measures into folders from the report view. You can do this from the model view, but it makes for a muc nicer workflow to do it from the same view, where you create the measures.

The nicest thing would be to simply be able to directly right-click a display folder in report view and choose "New measure".
fbcideas_migusr
New Member
Status changed to: Completed