topic Re: Line Chart Colour: line/area colour by Value in App Development

Line Chart Colour: line/area colour by Value

americanetsMD — Mon, 20 Nov 2023 12:23:57 GMT

Hi everyone,

could anyone please help me getting the colour correctly.

At the moment i colour the area by expression. If value is posivite - area is green, else , area is red.

What am i doing wrong here? 😞

The Formula i use to get the colour is:

if(

num(Aggr(
RangeSum(Above(Sum(WertKumuliert ),0,12))
, Jahr, Monat)/1000,'#.##0 TEUR')

>=0, '#6db133', '#e31c18')

Re: Line Chart Colour: line/area colour by Value

justISO — Mon, 20 Nov 2023 13:54:39 GMT

Hi, I believe this is how line chart works and unfortunately colors so, because chart colors not just area part below 0, but each period. In your case, '04 2023' is minus, so red in specific period interval, all other is green. To test that, you can color your measure by date (period). You'll see, that each period will be colored in equal intervals:

One way to avoid this positive area coloring with 'wrong' color is just to use bar chart.

Re: Line Chart Colour: line/area colour by Value

americanetsMD — Mon, 20 Nov 2023 15:15:53 GMT

Hi JustISO,

Thank you very much for your help and advice. I also thought about bar chart in order to avoid this misunderstanding, but was hoping i was wrong. Thank you once again. 🙂

Re: Line Chart Colour: line/area colour by Value

Or — Mon, 20 Nov 2023 15:20:21 GMT

Just adding to the above, which is correct - the chart as you want to display it is actually actively misleading. It suggests that the point in which the area crossed into the red is around April 4th, and by the end of April it was back into the green, even though it appears to show a singular value for the entire month of April. Perhaps a better representation here would be a combo chart, with color-coded bars showing the actual value and a line to show the trend?

Re: Line Chart Colour: line/area colour by Value

americanetsMD — Mon, 20 Nov 2023 16:04:17 GMT

Hi Or,

there can only be one singular value for each month, this is why i could also not understand why, when i just use period in format ('MM.YYYY'), i am getting, for example for April, the dates 09.04.2023 and 23.04.2023. This is a bit confusing 😞

Re: Line Chart Colour: line/area colour by Value

Or — Tue, 21 Nov 2023 09:38:37 GMT

This is typical when using a continuous axis - the labels are automatically generated based on what fits, rather than on the actual values. If you're sure you have data for every month (no missing/blanks), you can disable the continuous axis and use a discrete one.