# Creating Faceted Charts with Multiple Measures and Independent Axes

**URL:** <https://community.omni.co/t/creating-faceted-charts-with-multiple-measures-and-independent-axes/376>\
**Category:** Visualizations\
**Created:** [August 7, 2025, 4:31pm UTC](https://community.omni.co/t/creating-faceted-charts-with-multiple-measures-and-independent-axes/376 "2025-08-07T16:31:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![conor](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/conor/32/45_2.png) [@conor](https://community.omni.co/u/conor)\
**Post date:** [August 7, 2025, 4:31pm UTC](https://community.omni.co/t/creating-faceted-charts-with-multiple-measures-and-independent-axes/376/1 "2025-08-07T16:31:02Z")

</div>

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`. ![Prepare your dataset](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/a08b13b45b561f97f553d1bf158c05b256a099d8.png)
2. Select `Options`→`Swap rows and columns` to transpose your dataset to work better with the faceting approach ![Data as a result of Swap rows and columns](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/689715eec6e2284c167cf1d78e80d920e3c8e608.png)
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.

---

<div class="post-metadata">

**Author:** ![mbourqui](https://avatars.discourse-cdn.com/v4/letter/m/977dab/32.png) [@mbourqui](https://community.omni.co/u/mbourqui)\
**Post date:** [January 14, 2026, 3:25am UTC](https://community.omni.co/t/creating-faceted-charts-with-multiple-measures-and-independent-axes/376/2 "2026-01-14T03:25:10Z")

</div>

I appreciate the tip! However, when I do this it breaks my drill views, presumably because “Measure Name” and “Measure Value” aren’t available.

---

<div class="post-metadata">

**Author:** ![conor](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/conor/32/45_2.png) [@conor](https://community.omni.co/u/conor)\
**Post date:** [January 16, 2026, 2:10am UTC](https://community.omni.co/t/creating-faceted-charts-with-multiple-measures-and-independent-axes/376/3 "2026-01-16T02:10:20Z")

</div>

That’s a fair call out and the trade off with swapping rows and measures in a pivot.

What could be a good workaround with our new containers/pages layout would be to have a container of 3 graphs and vertically distribute them in a container to stack them perhaps.