Forum Discussion
Help needed filtering line value in Line and Cluster Column Chart
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?
2 Replies
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
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
