How can we improve Power BI?

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,

969 votes
Sign in
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Naji El Kotob shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Sign in with: Facebook Google
Signed in as (Sign out)
  • Jeff Birrer commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I really miss this function, or at least just let me change the order how the measures appear within a table.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

  • Jack Wells commented  ·   ·  Flag as inappropriate

    You can kind of create these but it's a bit of long winded method and not really well advertised. Would be helpful if we just had a "create measure folder" button.

  • Mike commented  ·   ·  Flag as inappropriate

    Sounds like you need to look into packaging your data up into Tabular/OLAP cubes or even SSIS packages then you can create your structures.

  • Tom commented  ·   ·  Flag as inappropriate

    you can create measure tables by creating a manual table with 1 empty column, then add/move a measure into that table then delete the column. This will create a "table" with only measures contained in it. Then next time you reload the model it will change the icon to a measure icon and pin it to the top

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.