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 Folderproperty 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:
Looking for more Power BI tips? Take your pick from our catalogue of Power BI trainings.f schrijf je in voor deXylos Power BI Day van woensdag 27 april 2022. an event full of inspirational sessions about the Power applications.