There is often a set of standard views that users like to see when they use a model, for example, we might expect any user that uses the
Products table would automatically like to see only the
Sub Category fields. Of course, they are not restricted from adding other fields to a control, however, when they use the table, we might like to give them the option of automatically adding those fields.
This recipe looks at how that can be achieved (and used).
This recipe uses the
Sales Model 2013.xlsx workbook available from the online content. There is no dependency on prior recipes.
Let's start by examining Power View's behavior before the model is configured for this action.
Create a new Power View report. Double-click on the
Productstable (note that nothing happens).
Launch the PowerPivot window and activate the
Click the Default Field Set button to launch the Default Field Set dialogue.