cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors