Forum Discussion

DHB's avatar
DHB
Helper V
2 years ago

Conditionally Format Bar Colour Within a Small Multiple

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

Need Help

5 Replies

    • DHB's avatar
      DHB
      Helper V
      2 years ago

      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's avatar
        Uzi2019
        Community Champion
        2 years ago

        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

    • Uzi2019's avatar
      Uzi2019
      Community Champion
      2 years ago

      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!