Organize your model

This article provides tips on how to organize your Model in Power BI.

The fields list tends to get longer when you start creating your own measures or columns. You can create a new table to store your calculated fields to make them easier to use.

Create a Measure Table:

Issue Example: The field list on the original table is longer due to my calculated measures. I want to move all my measures to a new table.

1. Go to the Modeling tab and click New Table.
   
2. Name the table "Measures Table" and click the checkmark
   
3. From the Fields panel, click on one of the measures you created. Change from the Home table to "Measures Table". 
   
4. You now see the measures have moved to the Measures Table. 
   
5. Repeat step #3 to move other measures to the new table.
    
6. On the Measures Table, the Column field is created automatically. Right click the Column field and choose Hide.
    
7. You see all of the measures in one table, which make you easier to find measures for your visuals.
   

Hide fields:

1. Go to the Model Pane 
2. Since the Acad_career table has been created, the model now has two ACAD__CAREER fields. This creates confusions, so ACAD_CAREER from the Census table should be invisible.  Click the field and click button for "Is hidden" under Properties.
    
3. Now the ACAD_CAREER field from Census table has been hidden.
    
4. Check for other fields that can be hidden.