Conditionally Format Bar Colour Within a Small Multiple

[DHB]

Hi all,

I’m not sure if what I’m trying to do is possible.  I have a line and column chart that uses countries as small multiples. 

What I’d like to do is conditionally format the colours of the bars within each small multiple so that not all the bars in ‘1’ are green because they have the highest totals compared to every other country anyway.

And the first few bars in ‘3’ should be red and the last couple should be bright green.  Like this;

Any tips are gratefully received.  Even if you tell me it’s not possible that’ll save me a lot of time.

Thank you!!

DHB

[DHB]

All good, thanks @Uzi2019 

[Uzi2019]

Hi @DHB 
The solution your looking is not quite possible please accept this solution to close this thread so other people may find it helpful.

Thanks!

[Uzi2019]

Hi @DHB 
Please refer this video for gradient color formatting.
https://www.youtube.com/watch?v=Eop1HsBjWwo

And for conditional formatting only in Red and Green color please refer this video.
https://www.youtube.com/watch?v=lpdQmcUZATs

If my post helps pleae give kudos and accept it as a solution!
Thanks

[DHB]

I've used conditional formatting and gradients as you can see in the screen shots but I want to get it to apply within small multiples.  So that #3 looks like the second picture and not how it is in the first.  To get it that way in the second picture I filtered to one country but I need to show all countries as small multiples.

[Uzi2019]

Hi @DHB 
I got your point. 
I have checked, Unfortunetly there is no such setting available under small multiple. The solution you are looking for is not quite possible. 

Thanks