Creating Faceted Charts with Multiple Measures and Independent Axes

[conor (Conor O'Mara)]

If you have a dataset with multiple measures (and no dimensions in the pivot) and want to plot them on a dual-axis chart in the same visualization but faceted, here’s a trick for you.

Step-by-step instructions

1. Prepare a dataset with multiple measures, Order Count and Total Sale Price.
   
2. Select Options→Swap rows and columns to transpose your dataset to work better with the faceting approach
   
3. Toggle to chart the data. Select the bar chart visualization type.

   1. Add Measure Name to the Rows or Columns in the Small multiples vis configuration section.

   2. Add the Measure value to the Left axis.

   3. This will result in multiple plots per measure on the rows or columns (whichever you choose).

      

   4. By selecting the Small multiples options, you’ll have the option to select independent axes.