topic Re: 2 Different color in one line chart in App Development

2 Different color in one line chart

Pooja_D — Fri, 28 Jul 2023 11:32:21 GMT

Hello Team,

We have prediction data.

I want to show in line chart
1. if month of January 2023 to current month(July 2023) data appear in one color
2. And remaining data for.e.g. Next month is august 2023 to Dec 2023 data should come in another color?

kindly suggest.

Thanks.

Re: 2 Different color in one line chart

justISO — Mon, 31 Jul 2023 06:48:52 GMT

Hi, in line chart properties menu, under 'Appearance'->'Colors and legend' choose color 'by expression' and describe condition for your needs, f.e. below is used expression, where 'period' is a date:
if(MonthEnd(period)<=MonthEnd(today()), LightRed(), Green())

Re: 2 Different color in one line chart

Pooja_D — Thu, 03 Aug 2023 12:35:14 GMT

Hello @justISO

Thanks for reverting.

It's working.

Thanks.

Re: 2 Different color in one line chart

gaddeonline — Fri, 22 Sep 2023 04:57:01 GMT

Hi @justISO,

This solution helpful, if we have only one measure in the chart. If we have second measure in the chart and don't want the two colours for the second measure, how do we skip/exclude the second one from the colour expression.

Please refer the below screenshot. The second line shouldn't be impacted.

Thanks and Regards

Mahesh Gadde

Re: 2 Different color in one line chart

justISO — Fri, 22 Sep 2023 06:11:36 GMT

In this case, use Combo chart, not Line chart. Add you dimension and 2 measures. Under each measure here are 'More properties' button and in here you must set both measures as Line and in Primary axis. Additionally, you can set color for each line, not for whole chart: