3 Replies Latest reply: Apr 26, 2016 4:47 PM by Michael Granillo RSS

    Struggling to color a grouped bar chart

    Mariana Rodrigues da Silva

      I need to build some bar charts with grouped information, like this:

      Capturar.PNG

      So far, it's set as Multicolored, but I wanted to pick the colors By Expression.

      The thing is, each group of info in the bar come from a different colunm in my database ("Restaurants Revenue", "Coffee Places Revenue", "Candy Shops Revenue", and so on).

      I know that if they were all in the same one, I could use something like IF([XXX]='YYY',Blue(),Red()), but all my measures come from different fields/columns, so I dunno how to organize the expression. What I've tried so far didn't work, so anyone has an idea to solve it? Thank you a lot in advance.