In a Vertical Bar Chart, is there a way to color specific bars based on a condition?
I created a calculated field to distinguish the values:
ifelse(
<condition>,
'Highest',
'Normal'
)
However, when I drag this field into the Group/Color field well, it splits the visual into two side-by-side columns (Clustered Bar style) — one for ‘Highest’ and one for ‘Normal’.
I don’t want two separate columns per x-axis value; I just want the single bar to change its color. How can I achieve this?
using Highcharts visuals if you need to show several metrics side-by-side with highlighted max values. Color is a property of a bar in Highcharts, so it should be pretty straightforward to customize. You also can turn on automatic color calculation depending in value (colorByPoint).
I am using Small Multiples to facet my data by week. The standard Vertical Stacked Bar Chart workaround fails to apply the highlighting correctly in this layout. Is it possible to configure the Highcharts Visual to handle Small Multiples dynamically while highlighting the highest column in each facet?
Small Multiples can be implemented in native Highcharts visuals (using JS). Unfortunately I don’t know if it can be done in QuickSight. I never tried to use the fuctionality that is needed for this. Looks like a small PoC is needed. BTW, a quersion like this was alrady asked, but there was no answer How to Create Small Multiples of Box Plots in Highcharts for Large Datasets?
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.
Since I haven’t received any further updates from you, I’ll treat this inquiry as complete at this time. Please feel free to create a new post if you have more questions.
