Skip to main content Skip to complementary content

The second sheet: Product Details

In the second sheet you will make a bar chart and treemap that focus on products. Then you will add filter panes so you can filter by date and region.

Product Details sheet when finished

Product Details sheet when finished.

You will start your work in standard edit mode. Once you create your visualizations you will use advanced edit mode to customize them.

Adding the bar chart

The next visualization is a bar chart showing the Top Sales. Make sure that Advanced properties is toggled off.

  1. Go to Fields, and drag the Product Group field to the sheet and add it as a dimension.

  2. Add Sales and Margin as measures.

    By default, the measures are grouped when you add a second measure to a bar chart.

  3. Under Properties > Visualizations, select vertical bar chart.

  4. Under Presentation > Labels, select the Show value labels check box.

Adding the treemap

Treemaps display hierarchical data by using nested rectangles. Use a treemap when space is constrained and you have a large amount of hierarchical data that you need to get an overview of. Treemaps should primarily be used with values that can be aggregated.

For more information, see Treemap.

In this treemap you will create a product hierarchy.

  1. Click Add item below the bar chart to add a new visualization.

  2. Add Product Group, Product Type, and Item Desc as dimensions.

  3. Add Sales as a measure.

  4. Under Properties > Visualizations, select treemap chart.

  5. Under Presentation > Labels, add the title: Product Treemap.

Customizing your charts in advanced edit mode

Now that all the visualizations have been created, you will switch to advanced edit mode to customize them. In the top right, toggle on Advanced options.

Customizing the bar chart

  1. Select the bar chart.

  2. Go to Sorting. Order your dimensions and measures like this:

    1. Sum(Sales)

    2. Sum(Margin)

    3. Product Group

  3. Click Sum(Sales). Set Sorting from Auto to Custom. Select Sort numerically.

    Your bar chart is now ordered from best selling to worse selling.

  4. You can add expressions in chart titles. Go to Appearance > General. Find Title, and click on Expression.

    The expression editor opens.

  5. This expression will resolve to show total sales:

    ='Total Sales: $'& Round(Sum(Sales)/1000000, 0.1) & 'M'

Customizing the treemap

  1. Select the treemap.

  2. Under Appearance > Colors and legend, set Colors from Auto to Custom.

  3. Select By measure in the list.

Adding the filter panes

The purpose of the filter panes is to filter out a limited data set, which you can analyze and explore.

For more information, see Filter pane.

You will now reuse the Period filter pane and the Region filter pane that you saved as master items.

  1. Resize the bar chart and treemap so that there is space on the left for two filter panes.

  2. In the assets panel, click Linked Object to open Master items.

  3. Click Visualizations.

  4. Drag the filter pane Period to the sheet and resize it.

  5. Drag the filter pane Region to the area below Period and resize it.

This sheet is complete. In the top right corner, click Next to move to the Customer Details sheet.

Learn more

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!