Enable and Configure Column Swapping for a Visualization

Enable column swapping for a visualization that uses a vertical axis, horizontal axis, or legend, and specify which columns are available for consumers to use.

For adding or removing columns from tables and pivots, see Enable and Configure Adding Columns for Tables and Pivots.

You specify which columns are available for column swapping in the visualization by adding them to the Related Columns section of the Grammar pane. Related Columns also holds columns that you want to use for Contextual Insights. For more information, see Enable and Configure Contextual Insights for a Visualization.

If you don't want to include these columns in column swapping, you can select the column in the Related Columns section and deselect the Use in Column Swapping option from the menu. The column's Treat As icon appears gray when the column isn't used in column swapping.
Description of column_swap_deselect.png follows
Description of the illustration column_swap_deselect.png

  1. On your home page, hover over a workbook, click Actions, and select Open.
  2. Select a visualization.
  3. Click Properties and then click Advanced Advanced properties icon.
  4. Under End User, in the Column Swap row, click Off to turn it to On.
    Description of column_swap_enable.png follows
    Description of the illustration column_swap_enable.png

  5. Click Grammar.
  6. From the Data pane, drag the columns to use for column swapping to the Related Columns section of the Grammar pane.
  7. Click Save.