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.
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.
Solved! Go to Solution.
Hey @jpellegrini ,
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.
Hey @jpellegrini ,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.