Help needed filtering line value in Line and Cluster Column Chart

[matty_pants]

I have a Line and Clustered Column chart where (A) columns are a volume, (B) the line is a cost, and (C) the Common Axis is month, and (D) there is a Page Filter of "Years" with a selection of three years.

The resulting clustering of columns is groups of years for the volume for that month and year. The resulting line, which is where the problem occurs, appears to be the sum of all three years. I need the line to provide only the sum for one year not all three. How is this achieved?

[v-yuta-msft]

@matty_pants ,

The in the value field of the line, which column or measure you put in it? Could you share some details? If possible, please share some sample data and dax formula you are using.

Regards,

Jimmy Tao

[matty_pants]

Hi Jimmy

This is what I am woring with for data. The "Energy Cost" is the line and "Energy, kWh" the columns. There should be three "School Year"s represented. 

Thanks!

Month	Energy Cost	Energy, ekWh	School Year
1	$31,889	203257	2015/2016
1	$40,841	245247	2016/2017
1	$38,180	249930	2017/2018
2	$32,424	188018	2015/2016
2	$35,753	228831	2016/2017
2	$32,666	227862	2017/2018
3	$33,236	191805	2015/2016
3	$41,660	248320	2016/2017
3	$37,664	238259	2017/2018
4	$35,581	182666	2015/2016
4	$41,625	230085	2016/2017
4	$36,302	212499	2017/2018
5	$30,440	181614	2015/2016
5	$41,029	232810	2016/2017
5	$33,332	201267	2017/2018
6	$31,444	181605	2015/2016
6	$38,370	211231	2016/2017
6	$37,030	183376	2017/2018
7	$25,728	142396	2015/2016
7	$41,379	222487	2016/2017
7	$35,675	169576	2017/2018
8	$27,643	133681	2015/2016
8	$37,563	206970	2016/2017
8	$34,319	161836	2017/2018
9	$21,373	177544	2015/2016
9	$31,838	179647	2016/2017
9	$35,592	224816	2017/2018
10	$23,977	199018	2015/2016
10	$30,742	201996	2016/2017
10	$45,528	239785	2017/2018
11	$23,376	202134	2015/2016
11	$35,023	221883	2016/2017
11	$42,208	258850	2017/2018
12	$23,268	194529	2015/2016
12	$39,518	228374	2016/2017
12	$45,242	245092	2017/2018