I need to build some bar charts with grouped information, like this:
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.