Database Reference
In-Depth Information
Field Well : This is located in the bottom-right corner and is where you drag
fields from the field list and drop them so they appear on the canvas. It also
provides the properties of any object currently selected on the canvas so that
you can control the appearance and behavior.
Filters Area : This is used to restrict the amount of data displayed in the
canvas area. It can be minimized by clicking on the > toggle at the top of the
filters area or hidden completely by clicking on the Filters Area button on
the ribbon.
Enhancing data models
As mentioned in the previous sections, possible data sources for Power View are a
PowerPivot for SharePoint workbook or an Excel 2013 data model. Both allow you
to view and edit the data models in PowerPivot while in Excel. A benefit is that it
allows you to make enhancements to the data model before users start to create
reports against it in Power View. The enhancements can also be made to a tabular
model via a Tabular Analysis Services project in SQL Server Data Tools ( SSDT ).
The following are some of the enhancements you can make:
Default Field Set : This setting is used for a table and gives you the ability to
select default columns and measures and define the preferred order. Then,
these columns and measures are automatically added to the Power View
report canvas when you create a report and click on the table name displayed
in the field list in Power View. This will help to reduce redundant steps when
using a data model in a report. To set the default fields for a data model,
go to a PowerPivot window and on the Advanced tab, there is a Reporting
Properties section with a Default Field Set button. Click on this button and
you will see the Default Field Set dialog box (see the following screenshot).
To set the default fields for a tabular model, in SSDT, go to the properties of
the appropriate table, and in the Default Field Set property, click on Click
to edit .
 
Search WWH ::




Custom Search