Line Chart showing spike due to decimal values

[adhumal2]

All above values are basically 34.80 after rounding, However the line chart is showing spike due to minor deviation in the decimal values as you can see on the chart.

I am expecting a straight line as all values are basically 34.80....How can I do it?

[AllisonKennedy · Accepted solution]

You can try a couple of things: 

Change the start and end values for y-axis for the line so that it's not so zoomed in https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-customize-x-axis-and-y-axis

Format or change data type for the measure so that it displays as 38 instead of keeping so many decimal places: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types

Use the ROUND option in Power Query to truncate the values (only works if this is a column build from data source)

[amitchandak · Accepted solution]

@adhumal2 , because of small range power BI using a very small range. Change the start value 0 (Y-Axis). Or control the decimals

[AllisonKennedy · Accepted solution]

You can try a couple of things: 

Change the start and end values for y-axis for the line so that it's not so zoomed in https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-customize-x-axis-and-y-axis

Format or change data type for the measure so that it displays as 38 instead of keeping so many decimal places: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types

Use the ROUND option in Power Query to truncate the values (only works if this is a column build from data source)