Although very simple, still I see many Power BI reports with no organized way of separating measures. When you use Power BI for a while, you will gradually have more DAX measures and calculations, and having them organized under folders is always helpful. In this very short article, I’ll explain how you can use Display Folders in Power BI to organize your measures properly. If you like to read more about Power BI, read Power BI book from Rookie to Rock Star.
If you have just added calculated columns and measures in Power BI solution, your file will look like this in Power BI Desktop:
And this is an example of a file with only a few measures. I have seen examples with over 100 measures under a table. You can use the Search box of course to find something, but having them organized is always helpful.
What is the Display Folder?
It is simple to add a display folder in Power BI. Display folder is a virtual folder which can be used for fields (columns), calculated columns, and measures to group them together. Here is how a display folder looks like:
Creating Display Folder
One of the easiest ways to create a display folder is to go to the Model tab in Power BI Desktop.
Then select a column, measure, or calculated column (you can select multiple items using Ctrl+Click), then under Properties, you will see the Display Folder
As soon as you press Enter, you will see all of those measures (and/or columns) under a folder under that table:
If you want, you can create subfolders too. The way to create it is to put a in the display folder name, here is an example:
and this is how it will look like:
Each measure should be part of a table, however, that table would be like a placeholder only for that measure. Because the calculation of the measure would work regardless of which table it is located under. So it means that it really doesn’t matter which table you put your measures under, however, there are two approaches for this:
Put measures under their related tables
One approach is to put sales measures under Sales table, inventory measures under Inventory tables, etc. If you want to move measures from one table to another table, here is how you can move it:
Select the Measure (either in the Report tab or Data tab), then from the Modeling tab above, change the Home Table:
Put measures under a measure table
Another approach is to create one (or more) blank tables with no columns or fields, and then move all measures under that. Here is more explanation about it.
Having an organized list of measures is super helpful in further maintenance of your Power BI model. It is a simple work that saves you a lot of time in the future. Using tools such as Power BI Helper is also helpful to understand your model and DAX measures much more in details. Do you use the display folder or measure tables? if not, please let me know why, if yes, tell me down in the comments below how do you use it.