Power BI grouping fields within a table

I have a fact table that now contains many measures and calculated columns. So many in fact that its quite difficult to scroll through.

There is now a way to group all your fields within a table to make it easier to use.

Lets look at the first group. I have lots of measures relating to rolling Quarter. These can all go in a folder together

Go to model view where you can find Properties for the fields

Click on one of the fields in your table that you want to group and set the Display folder name

You can then go through each field and set the display folder to group the measures

To speed up the process, hold down ctrl and select multiple columns and set the Display column for all the selected fields.

this makes it much easier to look after your measures

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create your website with WordPress.com
Get started
%d bloggers like this: