Power BI tip: Use folders to structure your measures

In many Power BI datasets, you’ll notice a separate table containing measures.  While this isn’t really necessary, it can be useful.

The downside is that as the number of measures grows, this table will be absolutely flooded with measures, which makes it hard to find the measure you need.

The usual solution for this problem is creating folders in the table... but at first sight, it looks like you can only create folders at the table level, not within the folders themselves.  It is possible, though - if you know how.

Have a look at the picture below.  This measures table has a folder called Base Measures at the top level (and several other folders that aren’t shown in this screenshot).
In this folder, you’ll see 3 subfolders: Other, Revenue, and Total Quantity.

The question is: how did I create those subfolders? Well, it’s pretty straightforward. Just follow these steps:

  • Switch to the Model tab (where you can see relationships - this is currently the only place where you can create folders).
  • Select 1 or several measures to be bundled in a (sub)folder.
  • Go to the Display Folder property under Properties and enter:
    • Base Measures\Total Quantity

That’s it! The only thing you need to do to create subfolders is use the \ symbol.  You can create sub-sub-subfolders the same way by entering something like:
Main folder\sub1\sub2\sub3

Looking for more Power BI tips? Take your pick from our catalogue of Power BI trainings.

Tip: on October 21st, we’re organising our Xylos Power Day - an event full of inspirational sessions about the Power applications.  Click here to learn more: https://learning.xylos.com/nl/power-day

Share this blogpost
Categories: Power BI
Tags: Power BI

Also interesting for you

Leave a reply

Your email address will not be published. Required fields are marked.

Bring your knowledge and skills to a higher level

Subscribe for our monthly newsletter and receive:

  • Exclusive tips & tricks
  • Information about our courses
  • Trends on courses
  • Invitations to seminars and events

Most popular courses