I am just starting the using quicksight , i have to highlight bar on conditions in bar chart visual.
Condition-i am showing say(Actual Value on y axis) and there is a field Thresold value and i need when Actual Value is greater then Threshold value then particular bar appear to red.
I am not able to do conditionally formatting in bar chart (although in pivot table).
Hi @mohitkaushik1,
My suggestion for this case would be to build a calculated field that you can then use in the ‘color by’ section of your bar chart.
I’m not sure of your available fields but it would essentially be something like:
ifelse(
{value field} >= ‘threshold amount’, ‘Above threshold’,
‘Below threshold’)
Then, apply this field to the ‘color by’ section of your visual, and you can ‘edit field colors’ for the calculated field:
So you can set your ‘Above threshold’ value to red and then the ‘below threshold’ value to something different.
Let me know if you have any additional questions
Hii @Brett, I apply your suggestion , after creating a calculated when i used that field in color it group the bar , But I need Individual bar not group chart , Something like this is in attached image
Hi @mohitkaushik1,
I’m wondering if your calculated field needs to be adjusted to include a date aggregation, I recreated this scenario and it worked for me.
In the top visual, I included the threshold calculated field in the color section where as in the second visual, I did not. They are showing the same information in the same layout but the coloring is different.
Here’s the calculated field I used:
ifelse(sumOver(Sales, [{Order Date}], PRE_AGG) > 10000, ‘above threshold’, ‘below threshold’)
Let me know if this works for you.