Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.