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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Ayupchap
Helper III
Helper III

Best way to share an axis for different data fields using the same scale?

all hope someone can help me

 

I am having trouble showing a line and clustered column chart whereby the shared axis is used for 2 sets of data each using the same scale.  This is what I have:

 

Field called ELA Goal which is 1, 2 ,3 or 4

 

Test Results for different tests (2 types in same area) which is also 1,2,3,4

 

Students who have data for both

 

There are two tables linked together by student name.  The results currently dont look right as can be seen here.  I know this as the line part is showing the wrong number of each (we only have 650 students and around 450-500 with actual data that should be shown in the line.

 

graph.PNG

 

Any help much appreciated!

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft Employee
Microsoft Employee

@Ayupchap

 

In this scenario, the reason why the line shows higher values is that the count of students names are aggregated on ELA Goal level (for both type). However, it's not possible to have line sliced by the column series which separates into multiple lines in this kind of combine chart. So I suggest you show the count of students in another chart and make it sliced my different type of tests.

 

Regards,

View solution in original post

2 REPLIES 2
v-sihou-msft
Microsoft Employee
Microsoft Employee

@Ayupchap

 

In this scenario, the reason why the line shows higher values is that the count of students names are aggregated on ELA Goal level (for both type). However, it's not possible to have line sliced by the column series which separates into multiple lines in this kind of combine chart. So I suggest you show the count of students in another chart and make it sliced my different type of tests.

 

Regards,

Thanks so much!  That does make sense.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors