topic Re: How to colour bar chart by two different master measures? in App Development

How to colour bar chart by two different master measures?

alespooletto — Fri, 03 May 2024 13:01:12 GMT

I have a bar chart that uses two different bar charts:

And I want to make it so that the two bar charts get coloured by the two different measures' values, so I made this code to put in the Colour by Expression section:

IF( VALUELIST('Availability', 'Availability Aggr.') = 'Availability Aggr.', IF( [Availability Aggr.] > '99%', GREEN(), IF( [Availability Aggr.] > '89%', RGB(255, 165, 0), RED() ) ), IF( VALUELIST('Availability', 'Availability Aggr.') = 'Availability', IF( [Availability] > '99%', GREEN(), IF( [Availability] > '89%', RGB(255, 165, 0), RED() ) ), BLACK() // Default colour ) )

Unfortunately as you can see, it always takes the default colour.

I saw in previous posts people suggesting to colour the maste rmeasure by segments within the master measure itself, I tried that but it didn't work as well.

Can anybody help me solve this ? Thank you!

Re: How to colour bar chart by two different master measures?

paulcalvet — Fri, 03 May 2024 15:31:00 GMT

Hello,

Try this in your expression, the measure is not a text but a number :

[Availability Aggr.] > 0.99,

Regards,

Re: How to colour bar chart by two different master measures?

alespooletto — Sun, 05 May 2024 08:42:53 GMT

Hey @paulcalvet , thanks for your response!

Unfortunately I tried to do that, but it doesn't work because it tells me that "All parameters to ValueList must be constant".

Do you have anything else in mind?