Line Chart Colors

AJ2024 — Fri, 10 Oct 2025 19:54:38 GMT

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?

Re: Line Chart Colors

robert_mika — Sat, 11 Oct 2025 06:41:58 GMT

Change to Combo chart

In More Option you can define color for each Expression

Re: Line Chart Colors

AJ2024 — Mon, 13 Oct 2025 15:05:29 GMT

Exactly what I need -- thanks!

topic Re: Line Chart Colors in App Development

Line Chart Colors

Re: Line Chart Colors

Re: Line Chart Colors