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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.