Skip to main content
Microsoft Idea

Power BI

Under Review

Grouping Fields into dimensions and measure

Vote (735) Share
abhishek sreesaila's profile image

abhishek sreesaila on 05 Jan 2015 04:25:31

Grouping Fields into dimensions and measures will allow for quickly locating the fields and helps design reports faster, rather than searching the long list of fields.

Administrator on 24 Jan 2015 06:11:41

Thanks Abhishek, this is a great idea! We'll consider it for the future, please add your votes it you agree!

Comments (32)
abhishek sreesaila's profile image Profile Picture

Deepak on 05 Jul 2020 22:23:01

RE: Grouping Fields into dimensions and measure

A must have functionality for a simple Self Service BI solution....

abhishek sreesaila's profile image Profile Picture

JB on 05 Jul 2020 22:20:55

RE: Grouping Fields into dimensions and measure

'@ GregDF - yes, many others do the same. It would work, but I would prefer the solution I mentioned in the original post - it works better for people who I'm trying to teach how to use Power BI.

abhishek sreesaila's profile image Profile Picture

JB on 05 Jul 2020 22:20:54

RE: Grouping Fields into dimensions and measure

Many times, I create Calculated Measures (and possibly Calculated Columns) for no other reason that to use them in other CM's and/or CCs. These measures of course are visible to anyone using the application, and can clutter things up and cause confusion. I can 'hide' them, but by doing so I am also hiding them from myself when I am quickly scanning the list on the right side of the application. It would be great to have a folder (or the ability to create one) wherein these could be deposited and kept out of the way - for pure housekeeping purposes.

abhishek sreesaila's profile image Profile Picture

Sergey.Kompaniets on 05 Jul 2020 22:16:50

RE: Grouping Fields into dimensions and measure

I hope this feature will be available with hierarchies

abhishek sreesaila's profile image Profile Picture

Gregory DF on 05 Jul 2020 22:14:55

RE: Grouping Fields into dimensions and measure

Hello. To achieve this, I create a new table called Measures with a distinct value from one of my fields. Then I hide this value, and add all my measures to this table so I can find them easily.

abhishek sreesaila's profile image Profile Picture

David Edwards on 05 Jul 2020 22:14:47

RE: Grouping Fields into dimensions and measure

In Desktop I would love the ability to group measures and fields into folders. For example I have a lot of measures that relate to dollar sales, unit sales, and cost. I'd love to be able to categorize the measures into folders that relate to the mentioned above. It would help minimize time spent looking for what you need.

abhishek sreesaila's profile image Profile Picture

Power BI User on 05 Jul 2020 22:12:36

RE: Grouping Fields into dimensions and measure

Please implement this feature (in de cloud) like the current display folders in SSAS Tabular. See also the https://ideas.powerbi.com/forums/265200-power-bi/suggestions/10858272-ability-to-group-fields-into-sub-folders
request. Showing a cube with a hundred measures in a long list is really not workable.

abhishek sreesaila's profile image Profile Picture

Power BI User on 05 Jul 2020 22:11:21

RE: Grouping Fields into dimensions and measure

I wonder if it would be possible to have the ability to create custom groups. For instance, one could combine fields from multiple dimensions or measure groups into one. Or one could separate fields from the same dimension into two separate groups. This would allow to represent the underlying fields in a more user-oriented way.

abhishek sreesaila's profile image Profile Picture

Amien on 05 Jul 2020 22:10:52

RE: Grouping Fields into dimensions and measure

This is really a must. I would like to set a specific field as dimension or measure field. And then i would be able for to me sort the field list. Or when i'm in visualisations --> Value, that measures will be shown. I also use alot of % in front of key fields. these should be one top. And last thing : Sort the field list on alphabetic order :)

abhishek sreesaila's profile image Profile Picture

Raimana CHAMPS on 05 Jul 2020 22:08:08

RE: Grouping Fields into dimensions and measure

Ideally, it would be nice if we could create folders and organize fields the way we want. For instance, when you create time calculations, you end up with many measures (Previous Year, YTD, Year over Year...) that could easily be put in one folder per measure for better readability.