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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.