Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

268



LESSON 29 New RepoRtiNg SeRviceS viSualizatioNS — SpaRkliNeS, Data BaRS, aND iNDicatoRS

11. Drag a data bar into the column that is directly above the sparkline.

FIGURE 299

12. Ensure that you select the first data bar from the Data Bar section of the Select Data Bar

Type screen (Figure 29-10).

FIGURE 2910

889633c29.indd 268 8/16/10 11:09:24 PM

Try It



269

13. Click OK.

14. Double-click the data bar.

15. Click the plus icon that is located to the right of the word Value and

select Total Sales from the column drop-down list (Figure 29-11).

16. Preview the report. Scroll down a little until to you see the Road

Bikes subcategory. Expand it to see the data bars.

17. Return to design view and right-click the column labeled Sales Trend,

select Insert Column, and then select Right.

18. Drag an indicator into the column next to the data bar.

19. Select the stoplight icons (Figure 29-12) from the Shapes section of

the Select Indicator Type screen.

20. Click OK.

21. Double-click the indicator.

22. In the Values section, select Total Sales from the drop-down list that has

Unspecified currently selected.

FIGURE 2912

23. Click the properties icon and then select Value and States from the left navigation pane

(Figure 29-13).

FIGURE 2911

889633c29.indd 269 8/16/10 11:09:24 ...