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

[Anonymous]

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.

[selimovd · Accepted solution]

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:

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.

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

Blog: WhatTheFact.bi