3736692 - unable to change color of dimensions with null values in story report chart

• Unable to change color of dimensions with null values in story report chart
• Color Cannot Be Applied to Null Dimension Values in Chart 
• Null Dimension Values Not Accepting Color Changes in Story Report 
  
  Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 
  
  

• SAP SuccessFactors HCM Suite
  • Analytics & Reporting
    • Story Report

1. Open a story and use a chart that includes a dimension with missing (null/blank) values.
2. Open Assign Colors → Dimension Members and try to set a color for the missing value.
   
   
   
3. Observe that the chart legend shows the missing value as “NULL” while the Dimension Members list shows it as blank or 0, and the color assignment does not apply consistently to the missing value.
   

The system interprets missing values differently in the chart legend and in Assign Colors → Dimension Members, causing inconsistent labeling (“NULL” versus blank) and preventing a consistent color assignment.

1. In the story’s Data panel, create a calculated column for the affected dimension to standardize missing values by replacing null/blank with a consistent label (for example, “NULL”).
   Formula: IF(ISNULL([Job Information#FoundationObjects#Department#Name_Description] ) , "NULL",[Job Information#FoundationObjects#Department#Name_Description] ) 
   
   Replace [Job Information#FoundationObjects#Department#Name_Description] with column ID that has been used in your report.
   
   
2. Use the new calculated column in the chart (replace the original dimension in the chart with this calculated column).
3. Open Assign Colors → Dimension Members and assign the desired color to the standardized “NULL” member.
4. Save and refresh the story to confirm the legend and the color-editing panel use the same label and the color is applied correctly.

• Is it possible to set a standard color palette for all story reports?
• Assign colours according to the chart values in the Story report

story report, story designer, assign colors, null values, blank values, missing values, dimension members, legend, chart colors, calculated column, calculated dimension, color palette, sac story, people analytics, color assignment , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , How To

SAP SuccessFactors HCM Suite 2511 ; SAP SuccessFactors Platform 2511