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,

844 votes
Sign in
(thinking…)
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 →

10 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

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.