cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
matty_pants
Frequent Visitor

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?

 

Capture.JPG

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@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

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!

 

MonthEnergy CostEnergy, ekWhSchool Year
1$31,8892032572015/2016
1$40,8412452472016/2017
1$38,1802499302017/2018
2$32,4241880182015/2016
2$35,7532288312016/2017
2$32,6662278622017/2018
3$33,2361918052015/2016
3$41,6602483202016/2017
3$37,6642382592017/2018
4$35,5811826662015/2016
4$41,6252300852016/2017
4$36,3022124992017/2018
5$30,4401816142015/2016
5$41,0292328102016/2017
5$33,3322012672017/2018
6$31,4441816052015/2016
6$38,3702112312016/2017
6$37,0301833762017/2018
7$25,7281423962015/2016
7$41,3792224872016/2017
7$35,6751695762017/2018
8$27,6431336812015/2016
8$37,5632069702016/2017
8$34,3191618362017/2018
9$21,3731775442015/2016
9$31,8381796472016/2017
9$35,5922248162017/2018
10$23,9771990182015/2016
10$30,7422019962016/2017
10$45,5282397852017/2018
11$23,3762021342015/2016
11$35,0232218832016/2017
11$42,2082588502017/2018
12$23,2681945292015/2016
12$39,5182283742016/2017
12$45,2422450922017/2018

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.