Conditional Color Formatting for Bar chart

Q&A
, ,
1

Hi,

I am having Horizontal Stacked Bar Chart and I am having 3 measures
Sales, Revenue and Profit

image
image853×508 18.7 KB

if the Sales is Greater Than Revenue the Grey color bar should be turn in to Green color. if Sales is less than Revenue then Bar should be in Grey color only.

How this can be done in Quicksight? Can someone help me to fix this

Thanks,
Satya

2

Hi @SatyaPaleti

Sorry, Currently QuickSight does not support conditional formatting for bar charts, including horizontal stacked bar charts, to change bar colors based on measure comparisons like Sales and Revenue. Conditional formatting is currently available for tables, pivot tables, gauge charts and KPIs.

I have tagged this as a feature request to promote visibility to the support team!

3

Hi @SatyaPaleti , you could use a Highcharts Visual. Use an inverted chart and the series type “column” (pay attention to grouping and staking). You can calculate colors in calculated fields and then use these values in Highcharts Visuals. You also can calculate colors in a visual, see this example https://democentral.learnquicksight.online/#Analysis-FeatureDemo-Highcharts-Visual 9. Lipstick chart. Highcharts Visuals are pretty flexible but the development process requires significant efforts.

{
“chart”: {
“inverted”: true
},
…
“series”: [
…
“type”: “column”,
…
],
…
}

image
image240×498 17.9 KB

4

Hi Satya @SatyaPaleti ,

I’m marking @Hrolol 's response as solution for now.
Please let us know if you have further questions.

Regards,
Arun Santhosh
Pr QuickSight SA