Bar Chart–Filtered and Color-Encoded

This view displays the sales and profit for all regions for the consumer market for each quarter in the year 2008. Additionally, the data are color-encoded by product category.

You can create the view with the following steps.

  1. Place the Order Date and the Region dimensions on the Columns shelf.

    The date is automatically aggregated by year, and headers are created for each dimension with labels given by the dimension member names. Change the date aggregation to quarter by selecting Quarter from the context menu.

  2. Place the Sales and Profit measures on the Rows shelf.

    The measures are automatically aggregated as a summation, and axes are created with labels given by the field names.

  3. Place the Product 1 - Category dimension on the Color shelf.

    Placing a dimension on the Color shelf separates the marks according to the members in the dimension, and assigns a unique color to each member. The color legend displays each member name and its associated color.

  4. Place the Order Date and Customer Segment dimensions on the Filters shelf.

    Filter Order Date to include only the year 2008. You open the filter dialog box by selecting Filter from the field’s context menu.



    Filter Customer Segment to include only the consumer market. You open the filter dialog box by selecting Filter from the field’s context menu.



The view is shown below. Note that the mark borders are not displayed so that color encodings are more easily identified.