nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Bar chart - series bar color depends on value in other series

jbeyl

Hi All,
 
I'm using bar chart in my report within two data series grouped by categories e.g. articles.
 
The first one represents supply and the second demand.
 
I would like to change a bar color for the specific category if the demand value is greater then supply value.
 
How can I achieve it? I was searching related topics on this forum but couldn't find anything similar.
 
Thanks in advance for any suggestions.
 
Rgds,
Jakub

Find more posts tagged with

Comments

PaulCooper

The simplest way to do this I can think of is make a new binding that flags the record if the demand value is greater then supply value. Then choose a stacked bar chart and set the optional Y-axis grouping to that flag field. In theory there are two stacked parts per bar but depending on if the demand value is greater than the supply value or not only one or the other will get displayed.
 
Paul

jbeyl

Hi Paul,
 
Thanks for the hint. I've created two more bindings for differences and using stacked bar chart got the result.
 
Rgrds,
Jakub