# Multiple dimensions in bar chart

**URL:** <https://community.amazonquick.com/t/multiple-dimensions-in-bar-chart/26712>\
**Category:** Q&A\
**Tags:** bar-chart, formatting, Business-Intelligence-Engineer, quick-sight\
**Created:** [March 1, 2024, 4:33pm UTC](https://community.amazonquick.com/t/multiple-dimensions-in-bar-chart/26712 "2024-03-01T16:33:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![PabloP](https://avatars.discourse-cdn.com/v4/letter/p/f17d59/32.png) [@PabloP](https://community.amazonquick.com/u/PabloP)\
**Post date:** [March 1, 2024, 4:33pm UTC](https://community.amazonquick.com/t/multiple-dimensions-in-bar-chart/26712/1 "2024-03-01T16:33:00Z")

</div>

I have a dataset with the following columns:  
Item Pre-Processing Quatlity Post-Processing Quatlity

Item: Numeric value  
Possible values for Pre- and Post-Processing Quality: Low, Medium, High

I need to show the quality results before and after applying a process.

For the initial results, I simply used a bar chart and displayed the “Pre-Processing Quatlity” field:  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/0/e/0ee3e7874808cf061844db4a102855d048b3c308.png)

The final results corresponds to a combination of the Pre- and Post-Processing Quality values:  
I created this calculated field:

```auto
Combined quality
ifelse(
    {Pre-Processing Quatlity} = "High" OR {Post-Processing Quatlity} = "High", "High",
    {Pre-Processing Quatlity} <> "High" AND (isNull({Post-Processing Quatlity}) OR {Post-Processing Quatlity} = ""), {Pre-Processing Quatlity},
    {Post-Processing Quatlity}
)

```

Then I created this chart:  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/d/b/db0ea6311a3e524b0b88800620428c8d16491517.png)

The analysis and dataset ara available in this link:  
[Quality results](https://community.amazonquick.com#Arena-dashboardId=22367601-af3f-468c-a460-753440632a2d&authorId=CU-772)

Is there a way to create a chart like the following one where the figures for Initial and Final results are shown together?  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/4/c/4c81cfea42e5642b422ab1cdd42c62c494246837.png)

If I add a second dimension to the Y-axis, it’s added as a drill-down layer.

* * *

\*Quatlity = Quality

---

<div class="post-metadata">

**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\
**Post date:** [March 1, 2024, 4:40pm UTC](https://community.amazonquick.com/t/multiple-dimensions-in-bar-chart/26712/2 "2024-03-01T16:40:55Z")

</div>

Hi @PabloP  
any chance you bring the Initial and Final as values into one dimension?  
BR

---

<div class="post-metadata">

**Author:** ![PabloP](https://avatars.discourse-cdn.com/v4/letter/p/f17d59/32.png) [@PabloP](https://community.amazonquick.com/u/PabloP)\
**Post date:** [March 1, 2024, 4:44pm UTC](https://community.amazonquick.com/t/multiple-dimensions-in-bar-chart/26712/3 "2024-03-01T16:44:26Z")

</div>

@ErikG, not quite feasible. In the real dataset I have some other columns in the dataset that are related. Basically, they shown values before and after processing. So if I move the Initial and Final as values into one dimension I would lose the relationship between them.

---

<div class="post-metadata">

**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\
**Post date:** [March 1, 2024, 4:59pm UTC](https://community.amazonquick.com/t/multiple-dimensions-in-bar-chart/26712/4 "2024-03-01T16:59:56Z")

</div>

Maybe you can build something with two visuals and overlap

![grafik](https://d1wl4jav5dp96l.cloudfront.net/original/3X/0/3/03e86e5c574d881382634fbddebc3573bc6d80e5.png)