SAP Knowledge Base Article - Public

3524763 - Axis labels on charts with Percent (%) based Measures are not completely shown

Symptom

Bar Charts with % Percent-based measure are not showing complete labels on the Y-axis.  Labels per Data values are shown on top of or beside each bar but the informational or reference labels along the axis are not shown or are incomplete (e.g. only 0% is shown and not the ranges 0%, 50 % 100%)

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

  • SAP SuccessFactors People Analytics
    • Stories in People Analytics

Reproducing the Issue

1. Create a Story and add a bar chart

2. Set a Percent-based field or column (could be standard or calculated columns) as Measure

3. Observe the Chart visual that is generated.  Notice that along the Y-axis, the percent labels or reference points are not displayed.  See below for reference:

Chart with Issue:

Chart that is showing more axis labels:

Cause

It is expected that charts would intelligently build the axis scale based on the data values. In the example  chart, the data values not more than 20%  (the largest percent is 18.05%) . If the Y-axis is built with 0% to 100% - the bars will be very less in height causing comparison difficult. And, if we show 0%-20% (since first highest round digit number for the given values is 20%), then the representation of data will be misleading.  As per chart guidelines (Hi-chart representation), the graph should not show % scale like that (0%-20%).

For other charts, there are values that reach beyond 100% e.g. 111% hence the scale of 0-100% is shown. 

Resolution

The axis scales vary based on data values. The focus will be more on how to make the data points readable and allow clear comparison to bring insights. The axis scale should be dynamic i.e. there are no fixed 0%- 100% access labels.  This is working as designed.

See Also

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/5bb8a7d18a3c479897fc64bc0820364a.html?q=chart+label#problem%253A-chart-does-not-display-all-of-the-expected-data-labels
Problem: Chart does not display all of the expected data labels
"When designing a chart, some of the labels may not appear when the chart is displayed.
The default setting for labels in charts is that when they overlap or collide with one another, or can't fit within the allotted space, they should be hidden."

Keywords

chart labels, y-axis, percent based measures, data labels,  , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , How To

Product

SAP SuccessFactors HCM Core 2405

Attachments

Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png