3. MEASURES

Add data under MEASURES in the data analysis panel to display the numeric values you are interested in viewing (such as sales or stock levels). Measure values will be grouped by the row and column hierarchies that have been added, and filtered by slicers, if any.

In a table visualization, each measure appears as a column. When selecting multiple measures together with a column hierarchy, the measure columns will reoccur for each column hierarchy value (e.g., Accessories).

4. ROWS

Hierarchies can be added under ROWS in the data analysis panel to group the measures by the selected values into rows (such as sales broken down by country instead of just a single total sales value). If you add multiple hierarchies, a row will be displayed for each combination of their values in the data.

5. SLICERS

Hierarchies can be added under SLICERS in the data analysis panel when you only want to filter by their values.

Slicer hierarchy members are not displayed anywhere in the visualization (including its tooltips), and only used to filter the other values. If you want to filter by values while also displaying them, you can place them elsewhere on the metric set.

After adding a hierarchy under SLICERS, click its filter icon and choose the values to filter by.

In a dashboard or another view, you can also add a filter to your view connected to this slicer, or connected to any other hierarchy or measure.

6. COLUMNS

Hierarchies can be added under COLUMNS in the data analysis panel to group the measures by the selected values into columns. Since measures are normally each displayed as a column, they will be repeated for each column hierarchy value. If you add multiple column hierarchies, the measures will be repeated for each combination of the hierarchy's values in the data.

Column hierarchy members appear as another row of column headers in a table visualization.