Microsoft Office Tutorials and References
In Depth Information
Figure 6-106. Setting up conditional formatting for the Date filter
Click on cell B2. This should be the All Promotions value for the Promotions filter. Be sure
to select the value cell (B2), not the label cell (A2).
Type “Promotions” into the name box, and press Enter.
The Excel spreadsheet is now ready to be published to SharePoint. For simplicity, we will store it in the
Dashboards library in our BI Center site (though it could be stored in any location trusted by Excel Services).
First, we’ll create a copy of the data connection we’re using.
From the ribbon menu, select Data ➤ Connections ➤ Properties.
Select the Definition tab. (See Figure 6-107 .)
Search JabSto ::