# How to dynamically switch field on a stacked bar chart

**URL:** <https://community.omni.co/t/how-to-dynamically-switch-field-on-a-stacked-bar-chart/434>\
**Category:** Visualizations\
**Created:** [December 26, 2025, 7:05pm UTC](https://community.omni.co/t/how-to-dynamically-switch-field-on-a-stacked-bar-chart/434 "2025-12-26T19:05:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![thaisgbraga](https://avatars.discourse-cdn.com/v4/letter/t/aeb1de/32.png) [@thaisgbraga](https://community.omni.co/u/thaisgbraga)\
**Post date:** [December 26, 2025, 7:05pm UTC](https://community.omni.co/t/how-to-dynamically-switch-field-on-a-stacked-bar-chart/434/1 "2025-12-26T19:05:07Z")

</div>

I’m new to Omni and i need to create a dimension and a control (or maybe a parameter) so users can choose with which column they want to see a bar chart stacked with color. For example I have total amount sales and i want to see it whether by sales team, OR state, OR country, OR another dimension column i have in my workbook. How can we do this in Omni?

---

<div class="post-metadata">

**Author:** ![James](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@James](https://community.omni.co/u/James)\
**Post date:** [December 26, 2025, 7:09pm UTC](https://community.omni.co/t/how-to-dynamically-switch-field-on-a-stacked-bar-chart/434/2 "2025-12-26T19:09:50Z")

</div>

Hi! You can use a field switcher control to swap out fields in a query

> **[Dynamically displaying tile fields with controls - Omni Docs](https://docs.omni.co/visualize-present/dashboards/controls)**

You’d add it to a dashboard from `Add`\>`Control`\>`Field switcher` and then you can configure which fields switch out for that control.

 ![Screenshot 2025-12-26 at 11.08.14](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/ffb57c830a8e5c219ddbec9b157748ceb40677ea.png)