If you want to move measures from one table to another table, here is how you can move it: One approach is to put sales measures under Sales table, inventory measures under Inventory tables, etc. 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 Because the calculation of the measure would work regardless of which table it is located under. The way to create it is to put a \ in the display folder name, here is an example:Įach measure should be part of a table, however, that table would be like a placeholder only for that measure. If you want, you can create subfolders too. 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Īs soon as you press Enter, you will see all of those measures (and/or columns) under a folder under that table: One of the easiest ways to create a display folder is to go to the Model tab in Power BI Desktop. Display folder is a virtual folder which can be used for fields (columns), calculated columns, and measures to group them together. It is simple to add a display folder in Power BI. You can use the Search box of course to find something, but having them organized is always helpful. I have seen examples with over 100 measures under a table. If you have just added calculated columns and measures in Power BI solution, your file will look like this in Power BI Desktop:Īnd this is an example of a file with only a few measures. If you like to read more about Power BI, read Power BI book from Rookie to Rock Star. In this very short article, I’ll explain how you can use Display Folders in Power BI to organize your measures properly. 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. Although very simple, still I see many Power BI reports with no organized way of separating measures.
0 Comments
Leave a Reply. |