Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Changing bar colour based on a Bar graph

Hi!   Is it possinle to chnage the colour of the bars in a bar chart based on a condition where keep all the bars for example blue if its before current month and red if its after current months. S...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    As I know, if you want to use conditional  formatting on bar color, you can't  add field in Legend. You could refer to my sample for details.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous , 

As I know, if you want to use conditional  formatting on bar color, you can't  add field in Legend. You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Great , can we do this same for clustured bar chart with multiple bars on it, because that is the problem I am facing now, I dont see the option for formating color when I have 2 bars(2 columns on Column value section)?

    • dax's avatar
      dax
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous , 

      I don't see Column value in clustured bar chart, if possible, could you please inform me more detailed information(such as your simple sample data and your chart setting)?

      Best Regards,
      Zoe Zhi

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.