kamilp's avatar
kamilp
Regular Visitor
4 years ago
Status:
Investigating

Y axis formatting - percentage issue

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.

 

 

3 Comments

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    Status changed:
    New
    to
    Investigating

    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's avatar
    kamilp
    Regular Visitor

    Hi, 

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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: