Skip to main content

Power BI

New

Group Measures and Columns

Vote (106) Share
rlansing's profile image

rlansing on 21 Jan 2016 08:00:06

I would like to group like measures and columns together. With a large database I may have up to a hundred measures and 20 columns and it would be easier to put them into groups like Product Data, Ranking, $ Volume, etc...

Comments (2)
rlansing's profile image Profile Picture

1e753da8 650d-4de6-8d63-8abe5ec68a75 on 05 Jul 2020 23:09:03

RE: Group Measures and Columns

I've prepared a mockup for this as well as a DAX Editor. Let me know what you think. In the grid you could add a column to label each measure and group them together.

Mockup: https://i.imgur.com/z6TBOQb.png?1

rlansing's profile image Profile Picture

8ade7929 3993-437b-a24c-921b685ed623 on 05 Jul 2020 22:22:46

RE: Group Measures and Columns

I totally agree with that. Alphabetic order makes sense. But having a measure for the revenue and the margin which is within one "topic" could be handled much easier by themes or groups.

There was a simmilar idea here in the community. Where the same problem should be handled by pining measures as favorites on top of the bar.

I think that a combination of both features would be fantastic.