Auto scale on line charts "freaks out" when graphing constant decimal data

[JenM]

Visualization:  Linear line chart with y-axis scale start/end set to auto.

I'm trying to graph decimal data that is derived using the DAX DIVIDE() function (in SSAS). I have configured my resulting data to have 2 decimal places. If I show data for multiple data sets (customers in this case), the scale displays correctly.

If, however, I slice down to a single customer whose data happens to not vary over the selected time scale, the auto scaling algorithm doesn't come up with reasonable start & end points. The only scale marker that shows is that of something close to my value (e.g., 1.00).  But what should be a straight line is wildly crooked. The tooltip correctly reports each data point as 1.00, but the line is drawn up, down & all over the place.

I suspect the scale is being set to nano proportions, and 1.00 might be being treated as 1.0000001 sometimes, 0.90000004 sometimes, etc. (Leading me to think that while I've set the precision to 2 decimal places, the internal precision is much greater. However, the same two numbers are being divided in each case, so you'd think they return the same result.) 

I would insert an image if I could figure out how to do so - I don't think what I've inserted below will work:

[JenM]

Your second tactic is an effective work-around.

The first tactic shows 1.0 out to 10 decimal places.

Thanks, Herbert!

[v-haibl-msft · Accepted solution]

@JenM

If you change the decimal places to 9 or 10 instead of 2, can you see there is any difference in the tooltip for the values?

BTW, if you use DAX ROUND() function to round the divide result to 2 decimal places, will the chart change?

Best Regards,

Herbert

[JenM]

The connection mode is Live Connection.

[v-haibl-msft]

@JenM

What is the connection mode here, Direct Query or Import? Could you please repost the screenshot since it cannot be displayed properly.

Best Regards,

Herbert