Naji El Kotob on 24 Jul 2018 05:27:15
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,
- Comments (14)
RE: Organizing Measures into Categories using Folders
Certainly a nice to have so +1 vote, but not my highest need relative to other voted items
RE: Organizing Measures into Categories using Folders
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"
RE: Organizing Measures into Categories using Folders
https://köpkörkort.com
Vi är det bästa och äkta företaget som tar dig under hela denna körkort process. Köp ett svenskt körkort utan skriftliga tentor. Vi tjänar våra kunder med värdighet. Vi erbjuder en snabb, säker och kostnadseffektiv lösning. Du kan köpa ett falskt körkort från denna webbplats och få det levererat till din adress.
RE: Organizing Measures into Categories using Folders
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.
RE: Organizing Measures into Categories using Folders
I believe this is already a feature that is a available. We have created "Measure tables" and used the DisplayFolder property to group like measures together.
RE: Organizing Measures into Categories using Folders
You can group measures into folders with the modeling feature: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/
RE: Organizing Measures into Categories using Folders
I really miss this function, or at least just let me change the order how the measures appear within a table.
RE: Organizing Measures into Categories using Folders
That's a cool feature that Tableau already has
RE: Organizing Measures into Categories using Folders
I went through it this week and thought I'd post an idea when I already found this one. This would be a great feature.
RE: Organizing Measures into Categories using Folders
Measure table is a sort of solution to this, but folder-structure would a bit more useful feature. We should be able to create multilevel folder-structure to group different kinds of measures to their own folders (for example, current year measures, previous year measures, percentage measures, count measures, sum measures, etc..). I know that SSAS would be a better solution in my case, but that's not always an option to the customer.