Bar Chart–Filtered, Color Encoded, and Level of Detail

This view displays the sum of the sales for a product category and is color-encoded by year. Additionally, the data display a level of detail given by the customer segment and are filtered to display a sales sum that is greater than $100,000.

You can create the view with the following steps.

1. Place the Sales measure on the Columns shelf.

   The measure is automatically aggregated as a summation and an axis is created with a label given by the name of the field.

2. Place the Product 3 - Name dimension on the Rows shelf.

   Row headers are created with labels given by the dimension member names.

3. Place the Order Date 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 Customer Segment dimension on the Level of Detail shelf.

   Filter the dimension to include only the Corporate and Small Business customer segments.

   
   
   
   
   

5. Filter Product 3 - Name by sales.

   Filter the Product 3 - Name field to include only products whose sales are greater than $100,000. To filter a dimension by a measure, use the Condition tab in the Filter dialog box. Select By Field and define the filter using the drop-down lists. Refer to i1011423.html#id13300921-8569-48a3-b71b-fb59bdac4455 to learn more about defining filters.

   
   
   
   
   

The view is shown below.

The total length of a given mark represents the sum of the sales for the associated product. Additionally, each mark is color-encoded by year. The length of a colored segment represents the contribution to the sales for the associated year. Finally, each colored segment can be separated into two levels of detail: corporate and small business.