Reply
avatar user
Anonymous
Not applicable

Help displaying line chart visual with high variance of Y-axis values

Hi there,

I am working on a simple line chart visual. I am seeking workarounds/tips and tricks to better display the data in my chart considering the variance of Y-axis values. One datapoint is the 2-3M range (seen in second screengrab) while the rest of of my datapoints are >50k (first screengrab) so it appears skewed and does not enable data labels that are an accurate representation of those lower values. Is there a way to break the Y-axis to be more demonstrative of all datapoints? If not, is there a way to not make the data labels on the lower values not "0M" but rather their value, e.g. "20k"? Any help would be greatly appreciated.

 

Screen Shot 2021-03-21 at 4.15.29 PM.pngScreen Shot 2021-03-21 at 4.22.31 PM.png

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @Anonymous ,

 

as far as I know this problem still exists with values of such a big difference.

Breaking the Y-axis would make it more visible, but you would change the data as the scale doesn't fit anymore.

 

You have 2 possibilities:

1. You can change the display units to thousands:

6.png

2. You could use the "Line and stacked column chart". There you can have two axis, one for the bars and one for the line. This helps in some cases.

7.png

 

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

1 REPLY 1
selimovd
Super User
Super User

Hey @Anonymous ,

 

as far as I know this problem still exists with values of such a big difference.

Breaking the Y-axis would make it more visible, but you would change the data as the scale doesn't fit anymore.

 

You have 2 possibilities:

1. You can change the display units to thousands:

6.png

2. You could use the "Line and stacked column chart". There you can have two axis, one for the bars and one for the line. This helps in some cases.

7.png

 

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)