SAP Knowledge Base Article - Public

3362036 - Prioritize Largest Absolute Value chart formatting option shows multiple label values on a Bar Chart in a Story in SAP Analytics Cloud (SAC)

Symptom

  • Multiple Bar Chart Data Labels display.
  • Prioritize Largest Absolute Value chart formatting option does not work. It displays more than 1 Data Label value on the Bar Chart.
  • Despite setting the Bar Chart Data Label formatting option: Prioritize Largest Absolute Value, it sometimes show more than 1 Data Label value per group of bar, in a Story in SAP Analytics Cloud.

Environment

  • SAP Analytics Cloud 2023.8.18

Reproducing the Issue

  1. In SAP Analytics Cloud, create a Story.
      
  2. Add a Bar/Column Chart with at least 2 Measures, and 1 Dimension.
     
  3. In the Chart Builder, under Color, show the Measure as Layered Bars.
     
  4. In the Chart Styling, under Labels, set the Data Label option:

         Avoid Data Label Overlap - Prioritize Largest Absolute Value.

  5. When viewing the Story, notice some group of bars show more than one label value. 
    The expectation is to only see the largest label value per group of bar.

       Bar_Chart_Prioritize_Largest_Absolute_Value.png

Cause

  • The Chart Data Label formatting option: Prioritize Largest Absolute Value, is an option to "Avoid Data Overlap Value". 
      
  • This option is not designed to only display the largest data label of all the group of bars, it is designed to show the largest value when data labels values overlapped, and will show more than 1 Data Label Values when there is no overlap.
      
  • In other words, it is designed to avoid the data labels to overlap other data labels and bar, and gives priority to the largest bar data label if the data label overlap with other data labels, or bars. If there is no overlap, then all the Data Labels that does not overlap will show, and this is why there is group of bars that show more than 1 Data Label.

Resolution

  • The Chart Data Label formatting option: Prioritize Largest Absolute Value, work as designed.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAC, graph, bar graph , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0