Y axis formatting - percentage issue

[kamilp]

Hello,

I have strange situation with Y axis formatting on line chart. Report contains metric as following:

Main Metric = DIVIDE( [Nominator $], [Denominator $], BLANK() ) 

Main Metric was formatted in the following way:

There are following line charts. In this example all Y-axises are formatted correctly.

The issue is visible if user select wider time range and Denominator equals BLANK for some months. Then Y-axis for Main Metric is formatted in incorrect way (as a Whole Number, not as Percentage). 

I understand that Main Metric for CY B on May and Jun equals BLANK because of Divide by blank. However, I don't understand why Y-axis shows Whole Number instead of Percentage.

[v-cazheng-msft]

Hi @kamilp,

I’ve tested based on the description but couldn’t reproduce this issue. What’s the version of your Desktop? Is it the latest version? If you try older versions, will you also see this issue?

Best Regards,

Community Support Team _ Caiyun

[kamilp]

Hi, 

It's 2.107.841.0 64-bit (July 2022) version. I didn't check that on another versions. 

[seanPham]

I'm also having a similar issue with the Y-Axis values. In my case, a measure is powered by dynamic formatting and when I change the X-Axis sort the values change from percentages to decimals: