cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## Plotting multiple series in a line chart

This is perhaps really simple but I'm stuck.  I have a table like the following

Year / Gender /  SchoolID / Class / Final Mark

I want to build a line chart like the below, where I could compare Boys with School A.  This seems like it would be simple to do but I can't figure it out.  Every time I put an additional dimension in it gives me a hierarchy (Boys from School A, Girls from School A, etc).  I want each dimension to be independent.  Thanks for the help!

1 ACCEPTED SOLUTION
Employee

Hi @michaelccdf,

If I understand you correctly, an alternative solution could be that creating 5 measures to calculate the average of final mark separately for (Boys, SchoolA, etc), then show all 5 measures as Values, and the Year column as Axis on the line chart to get the expected result in your scenario.

The formulas below are for your reference.

```Boys = CALCULATE ( AVERAGE ( 'Table1'[Final Mark] ), 'Table1'[Gender] = "Boy" )
```
`Girl = CALCULATE ( AVERAGE ( 'Table1'[Final Mark] ), 'Table1'[Gender] = "Girl" )`
`SchoolA = CALCULATE ( AVERAGE ( 'Table1'[Final Mark] ), 'Table1'[SchoolID] = "SchoolA" )`
`SchoolB = CALCULATE ( AVERAGE ( 'Table1'[Final Mark] ), 'Table1'[SchoolID] = "SchoolB" )`
`Everyone = AVERAGE ( 'Table1'[Final Mark] )`

Regards

2 REPLIES 2
Employee

Hi @michaelccdf,

If I understand you correctly, an alternative solution could be that creating 5 measures to calculate the average of final mark separately for (Boys, SchoolA, etc), then show all 5 measures as Values, and the Year column as Axis on the line chart to get the expected result in your scenario.

The formulas below are for your reference.

```Boys = CALCULATE ( AVERAGE ( 'Table1'[Final Mark] ), 'Table1'[Gender] = "Boy" )
```
`Girl = CALCULATE ( AVERAGE ( 'Table1'[Final Mark] ), 'Table1'[Gender] = "Girl" )`
`SchoolA = CALCULATE ( AVERAGE ( 'Table1'[Final Mark] ), 'Table1'[SchoolID] = "SchoolA" )`
`SchoolB = CALCULATE ( AVERAGE ( 'Table1'[Final Mark] ), 'Table1'[SchoolID] = "SchoolB" )`
`Everyone = AVERAGE ( 'Table1'[Final Mark] )`

Regards

Helper I

Thanks so much, this did the trick!

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors