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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
arock-well
Helper V
Helper V

Line and Stacked Column Chart Issue?

I'm using a line and stacked column chart where the X-axis is a Week Ending Date value, the Column Y-axis is EHTC in hours and Line Y-axis is Actuals in hours.

 

The Secondary Y-axis property is turned Off:

 

arockwell_0-1693416116875.png

 

An issue is happening where if the count of Week Ending Dates is less than 23 weeks, the Secondary Y-axis turns on for some reason.

 

Example A (correct): Greater than 23 weeks, this is working as expected with Secondary Y-axis off:

 

arockwell_2-1693416358736.png

 

 

Example B (not correct): Less than 23 weeks, but Secondary Y-axis turns on (see highlighted yellow):

 

arockwell_1-1693416279504.png

 

 

So in Example B, not only did the Secondary Y-axis turn on for Actual, but the scale between the hours in EHTC vs Actual are completely different now, which is causing issues with users viewing this visual to think there is something wrong with the data being presented.

 

Bottom line questions: Why is the Secondary Y-axis turning on when this is turned of in the settings? Why is the scaling so different between EHTC and Actuals when it does this?

 

Edit: When I say the Secondary Y-axis turns on, I'm referring to the visual itself when someone is viewing the report. The setting is still set to off even though the visual is showing it.

1 ACCEPTED SOLUTION
arock-well
Helper V
Helper V

Simply turning the Secondary Y-Axis property On and then Off again solved the issue. Don't understand why this fixed it.

 

arockwell_0-1693938649549.png

arockwell_1-1693938664552.png

 

View solution in original post

5 REPLIES 5
arock-well
Helper V
Helper V

Simply turning the Secondary Y-Axis property On and then Off again solved the issue. Don't understand why this fixed it.

 

arockwell_0-1693938649549.png

arockwell_1-1693938664552.png

 

arock-well
Helper V
Helper V

I may have found a solution through trial and error.  I first turned the Secondary Y-axis on:

 

arockwell_0-1693426171513.png

 

Next I turned Logarithmic scale on and Align zeros on, which disabled Logarithmic scale but kept it on:

arockwell_1-1693426204884.png

 

Then I went back and turned off Secondary y-axis to off:

 

arockwell_2-1693426219890.png

 

This “magically” realigned the EHTC and Actual hours to the same scale and doesn’t show the Actual scale on the right:

 

arockwell_3-1693426237628.png

 

 

What am I missing here?

Ritaf1983
Super User
Super User

Hi @arock-well 
Can you please provide some file with example to work with?

@Ritaf1983  I'll have to look into this as the associated data is proprietary to my company.

@arock-well 
You can prepare some dummy data, i need something to work with...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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