# How to display multiple progress bars in a single table cell?

**URL:** <https://community.amazonquick.com/t/how-to-display-multiple-progress-bars-in-a-single-table-cell/50872>\
**Category:** Q&A\
**Tags:** calculations, Business-Intelligence-Engineer, quick-sight\
**Created:** [December 10, 2025, 5:09am UTC](https://community.amazonquick.com/t/how-to-display-multiple-progress-bars-in-a-single-table-cell/50872 "2025-12-10T05:09:33Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![hyyitss](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/hyyitss/32/32265_2.png) [@hyyitss](https://community.amazonquick.com/u/hyyitss)\
**Post date:** [December 10, 2025, 5:09am UTC](https://community.amazonquick.com/t/how-to-display-multiple-progress-bars-in-a-single-table-cell/50872/1 "2025-12-10T05:09:33Z")

</div>

Hi QuickSight community,

I have a table with three separate columns showing percentage values (Fast\_Charging\_Percent, Normal\_Charging\_Percent, Slow\_Charging\_Percent). Each column currently has Data Bars applied.

What I want to achieve:  
Combine these three columns into a single column that displays all three values with their respective progress bars.

What I’ve tried:  
I created a calculated field using concat() and ifelse() to simulate progress bars with emoji characters (🟦🟩🟧⬜). This works but has limitations:

- Not as clean as native Data Bars
- Hits SPICE complexity limits when trying to add more granularity (8+ blocks)
- Emoji rendering can be inconsistent

My questions:

1. Is there a way to merge multiple Data Bar columns into a single column in a table visual?
2. Is there a better approach to display multiple progress indicators within a single table cell?

Any suggestions or workarounds would be greatly appreciated!

Thanks in advance!

 ![databar](https://d1wl4jav5dp96l.cloudfront.net/original/3X/f/0/f01529ef0a0e49b226794e0abb0157c1b78d19e7.png)

---

<div class="post-metadata">

**Author:** ![hyyitss](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/hyyitss/32/32265_2.png) [@hyyitss](https://community.amazonquick.com/u/hyyitss)\
**Post date:** [December 10, 2025, 5:11am UTC](https://community.amazonquick.com/t/how-to-display-multiple-progress-bars-in-a-single-table-cell/50872/2 "2025-12-10T05:11:47Z")

</div>

This is my current calculated field:

```auto
concat(
  'ConCon1 ',
  ifelse({Fast_Charging_Percent} >= 17, '🟦', '⬜'),
  ifelse({Fast_Charging_Percent} >= 33, '🟦', '⬜'),
  ifelse({Fast_Charging_Percent} >= 50, '🟦', '⬜'),
  ifelse({Fast_Charging_Percent} >= 67, '🟦', '⬜'),
  ifelse({Fast_Charging_Percent} >= 83, '🟦', '⬜'),
  ' ', toString(round({Fast_Charging_Percent}, 1)), '%
',  
  'ConCon2 ',
  ifelse({Normal_Charging_Percent} >= 17, '🟩', '⬜'),
  ifelse({Normal_Charging_Percent} >= 33, '🟩', '⬜'),
  ifelse({Normal_Charging_Percent} >= 50, '🟩', '⬜'),
  ifelse({Normal_Charging_Percent} >= 67, '🟩', '⬜'),
  ifelse({Normal_Charging_Percent} >= 83, '🟩', '⬜'),
  ' ', toString(round({Normal_Charging_Percent}, 1)), '%
',
  'ConCon3 ',
  ifelse({Slow_Charging_Percent} >= 17, '🟧', '⬜'),
  ifelse({Slow_Charging_Percent} >= 33, '🟧', '⬜'),
  ifelse({Slow_Charging_Percent} >= 50, '🟧', '⬜'),
  ifelse({Slow_Charging_Percent} >= 67, '🟧', '⬜'),
  ifelse({Slow_Charging_Percent} >= 83, '🟧', '⬜'),
  ' ', toString(round({Slow_Charging_Percent}, 1)), '%'
)

```

---

<div class="post-metadata">

**Author:** ![Hrolol](https://avatars.discourse-cdn.com/v4/letter/h/b3f665/32.png) [@Hrolol](https://community.amazonquick.com/u/Hrolol)\
**Post date:** [December 10, 2025, 7:41am UTC](https://community.amazonquick.com/t/how-to-display-multiple-progress-bars-in-a-single-table-cell/50872/3 "2025-12-10T07:41:27Z")

</div>

Hi @hyyitss , did you consider using [data bars](https://community.amazonquick.com/t/improve-table-readability-and-identify-outliers-with-data-bars-in-amazon-quicksight/14553)?

---

<div class="post-metadata">

**Author:** ![hyyitss](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/hyyitss/32/32265_2.png) [@hyyitss](https://community.amazonquick.com/u/hyyitss)\
**Post date:** [December 10, 2025, 7:51am UTC](https://community.amazonquick.com/t/how-to-display-multiple-progress-bars-in-a-single-table-cell/50872/4 "2025-12-10T07:51:17Z")

</div>

Hi @Hrolol

Thanks for your reply!

I have already considered and tried using Data Bars, as shown in my screenshot. However, what  
I’m looking for is to merge these three columns into a single column (like my test6 column), rather than keeping them as three separate columns.

So I’m wondering if there’s a better native solution I might be missing.

 ![11](https://d1wl4jav5dp96l.cloudfront.net/original/3X/e/b/ebe0a9ebe339db27fa86bc6f704d2df771dcc46a.png)

---

<div class="post-metadata">

**Author:** ![Hrolol](https://avatars.discourse-cdn.com/v4/letter/h/b3f665/32.png) [@Hrolol](https://community.amazonquick.com/u/Hrolol)\
**Post date:** [December 10, 2025, 8:28pm UTC](https://community.amazonquick.com/t/how-to-display-multiple-progress-bars-in-a-single-table-cell/50872/5 "2025-12-10T20:28:44Z")

</div>

Oh, I see. I see 2 possible options:

1. splitting a row into 3 ones
2. using a Pivot.

In the second case you can keep the left part as is and transform these 3 bars into 3 rows. But i did not use bars in pivot visuals so I am not sure that it will do work for you because max value will probably be the same for all 3 metrics. This concern is actual for the first case as well. I wish Data Bars gave us gave us the same level of control as Conditional Formatting.

---

<div class="post-metadata">

**Author:** ![JacobR](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/jacobr/32/37779_2.png) [@JacobR](https://community.amazonquick.com/u/JacobR)\
**Post date:** [December 23, 2025, 4:06pm UTC](https://community.amazonquick.com/t/how-to-display-multiple-progress-bars-in-a-single-table-cell/50872/6 "2025-12-23T16:06:48Z")

</div>

Hi @hyyitss,

Just checking back in since we haven’t heard from you in a bit. I wanted to see if the guidance shared earlier helped resolve your question, or if you found a solution in the meantime.

If you still have any additional questions related to your initial post, feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.

Thank you

---

<div class="post-metadata">

**Author:** ![JacobR](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/jacobr/32/37779_2.png) [@JacobR](https://community.amazonquick.com/u/JacobR)\
**Post date:** [December 29, 2025, 8:18pm UTC](https://community.amazonquick.com/t/how-to-display-multiple-progress-bars-in-a-single-table-cell/50872/7 "2025-12-29T20:18:16Z")

</div>

Hi @hyyitss,

Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.

Thank you
