SAP Knowledge Base Article - Public

2949549 - The color is displayed with opposite order in Bar/Column chart when there is a date dimension assigned in SAP Analytics Cloud (SAC)

Symptom

The following behavior occurs in SAP Analytics Cloud (SAC):

  • The color is displayed with opposite order in Bar chart when there is a date dimension assigned in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud (Enterprise) 2020.15.2

Reproducing the Issue

  1. Log on to SAP Analytics Cloud tenant and create a new story.
  2. Select a model which has date type dimension.
  3. Add a Bar/Column chart.
  4. In Dimension part, assign a date type dimension.
  5. In Color part, assign a dimension and color palette. 
  6. Notice that in the Bar/Column chart, the color is displayed with opposite order comparing with the color palette.

Cause

This issue is a by design behavior.

Resolution

When Time or Date Dimension is selected, the chart is expected to display the most recent data points.  By default, all of the retrieved data points are then sorted in reverse to display in chronological order, leading to the reversed order of colours.

There are the following two ways can be used for solving the issue:

  • Turn OFF Color Sync
      -> In the option for the Color dimension, choose Color Sync -> Unsync Colors
  • Apply a sort for the Date / Time dimension in the chart

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0