Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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?
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 |
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
103 | |
63 | |
44 | |
37 | |
35 |