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 ...
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 |