cancel
Showing results 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

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?

2 REPLIES 2
Community Support

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

Frequent Visitor

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!

 Month Energy Cost Energy, ekWh School Year 1 \$31,889 203257 2015/2016 1 \$40,841 245247 2016/2017 1 \$38,180 249930 2017/2018 2 \$32,424 188018 2015/2016 2 \$35,753 228831 2016/2017 2 \$32,666 227862 2017/2018 3 \$33,236 191805 2015/2016 3 \$41,660 248320 2016/2017 3 \$37,664 238259 2017/2018 4 \$35,581 182666 2015/2016 4 \$41,625 230085 2016/2017 4 \$36,302 212499 2017/2018 5 \$30,440 181614 2015/2016 5 \$41,029 232810 2016/2017 5 \$33,332 201267 2017/2018 6 \$31,444 181605 2015/2016 6 \$38,370 211231 2016/2017 6 \$37,030 183376 2017/2018 7 \$25,728 142396 2015/2016 7 \$41,379 222487 2016/2017 7 \$35,675 169576 2017/2018 8 \$27,643 133681 2015/2016 8 \$37,563 206970 2016/2017 8 \$34,319 161836 2017/2018 9 \$21,373 177544 2015/2016 9 \$31,838 179647 2016/2017 9 \$35,592 224816 2017/2018 10 \$23,977 199018 2015/2016 10 \$30,742 201996 2016/2017 10 \$45,528 239785 2017/2018 11 \$23,376 202134 2015/2016 11 \$35,023 221883 2016/2017 11 \$42,208 258850 2017/2018 12 \$23,268 194529 2015/2016 12 \$39,518 228374 2016/2017 12 \$45,242 245092 2017/2018

Announcements

#### 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 Monthly Update - June 2024

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

#### 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.

#### New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors