-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating
Microsoft Tabular Modeling Cookbook
By :
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 Category and 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 Products table (note that nothing happens).
Launch the PowerPivot window and activate the Products table.
Click the Default Field Set button to launch the Default Field Set dialogue.
Add...
Change the font size
Change margin width
Change background colour