topic Re: Help - Trend chart in Developer

Help - Trend chart

manojk_pbi — Wed, 13 Aug 2025 13:59:04 GMT

Hi Friends,

I have below data in model. How can we draw a line chart showing only Dec data of previous years and all months of the current year.

MMMYY	Forecast	ActualCost
6/1/2023	310000	41813.68764
7/1/2023	310000	75897.3089
8/1/2023	310000	40003.10025
9/1/2023	310000	117452.1421
10/1/2023	310000	56190.15467
11/1/2023	310000	72202.93116
12/1/2023	310000	128021.534
1/1/2024	297000	0
2/1/2024	297000	27656.29
3/1/2024	297000	43518.46
4/1/2024	297000	68786.15
5/1/2024	297000	119160.89
6/1/2024	297000	139212.38
7/1/2024	297000	143467.36
8/1/2024	297000	163607.49
9/1/2024	297000	188824.68
10/1/2024	297000	225715.05
11/1/2024	297000	269808.53
12/1/2024	297000	296341.22
1/1/2025	612000	0
2/1/2025	612000	26275.19
3/1/2025	612000	85800.02
4/1/2025	612000	116936.47
5/1/2025	612000	160379.43
6/1/2025	612000	187654.78
7/1/2025	612000	207702.24
8/1/2025	612000	207702.24
9/1/2025	612000	207702.24
10/1/2025	612000	207702.24
11/1/2025	612000	207702.24
12/1/2025	612000	207702.24

Re: Help - Trend chart

MasonMA — Wed, 13 Aug 2025 14:23:30 GMT

Hello @manojk_pbi

One of the solutions would be to create one Calculated column in the table with below logic,

flag = VAR CurrentYear = YEAR(TODAY()) VAR RowYear = YEAR([MMMYY]) VAR RowMonth = MONTH([MMMYY]) RETURN IF( RowYear = CurrentYear, TRUE(), IF( RowYear < CurrentYear, RowMonth = 12, FALSE() ) )

and use this flag column as a visual level filter as in below picture.

Hope this helps:)

Re: Help - Trend chart

manojk_pbi — Wed, 13 Aug 2025 15:28:19 GMT

Thanks for your reply. It is helpful. I am changing the graph to column chart in which we can avoid other months