Change the background colour of a single bar across 3 measures

[wonkymeister]

Hi all,

I have a single bar chart, that contains 3 expressions, count of greens, count of ambers, count of reds where the colours are values of one field – health_score (how many metrics have a health score of green, amber and red)

Ie for Amber’s

count({$<

               health_score = {'Amber'}

>}metric_id)

/

count({$<

               health_score = {'Green', 'Amber', 'Red'}

>}metric_id)

What I would like to do is change the colour portion of the bar that has the green expression to green, the amber expression to amber and the red expression to red. Ive tried changing the colour default to by expression and tried various bits of set analysis /nested Ifs but nothing works.

Any ideas?

[JordyWegman · Accepted solution]

Hi Wonky,

Try to create three measures and put them in your master items. Give your master items then a color for each one. Add these master measures to the bar chart and create a stacked bar chart. This should work for you.

Jordy

Climber

[Kashyap_R]

Hi

Create a master measure and use it in the chart 

Hope this helps

Thanks