Line Chart Colors

[AJ2024]

I have a line chart with 3 measures shown over time: [# of New Accounts], [# of Closed Accounts], and [# of Net Accounts]

I want each line to be a distinct color:

• [# of New Accounts] --> Green
• [# of Closed Accounts] --> Red
• [# of Net Accounts] --> Green or Red depending on whether the measure is positive of negative for the month

I thought I could achieve this by coloring the lines with an expression, here is what I have currently.

If([# of New Accounts]>'0', RGB(59, 147, 65), If ([# of Closed Accounts]*-1<'0', RGB(202, 17, 17),

If ([# of Net Accounts]>='0', RGB(59, 147, 65), If ([# of Net Accounts]<'0', RGB(202, 17, 17)))))

Right now, the measure isn't showing any errors. But all three lines have the same color RGB(59, 147, 65). So, it seems like all three measures are returning true for the first condition. 

Can anyone tell me if this is possible / where I'm going wrong?

[robert_mika · Accepted solution]

Change to Combo chart

In More Option you can define color for each Expression

[AJ2024]

Exactly what I need -- thanks!