How can I use the new conditional formatting on number chart?

[Former Member]

Hey Guys,

I had tried several times to use conditional formatting on chart under KPI > Numeric Point but with no success. Any ideas how we can make that happen?

I'd like to the change the background color, or the text color, according to the conditional formatting rule. Here is a video that claims SAP Cloud for Analytics already has this capability of last year https://www.youtube.com/watch?v=NG9XcZg31zU.

Here is an example:

[Viktor1]

pls note that the conditional formatting is now a sub-menu on the designer panel:

[Former Member]

Viktor,

Yes of course. That's understood.

Once you select Conditional formatting you go to "Model or Entire Story" > Measure > Colors and then you select colors.

But then nothing happens until you specify the chart that you want this conditional formatting to affect. With a bar chart, easy. But I just need an explanation on how it's done on a numeric KPI.

Also, follow up question: How did you add the items under assigned colors?

Thank you,

Mohammad

[JohnL]

Hi Mohammad,

First create a threshold in your story or model:

Then assign that Threshold (called Gross Profit) in the Color section of your Numeric chart:

[Former Member]

Thank you John! 🙂