My Oracle Support Banner

OBIEE 12c: Conditional Formatting On Bar Graph Does Not Work With 'Scale For %' (Doc ID 2367681.1)

Last updated on AUGUST 29, 2021

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


On : version, Analytics

Conditional formatting on bar graph does not change colors when the numbers change.
A graph has been created with percentages and conditional formatting has been set up to show a different color when the percentage is below a certain number.
But the color always remain the same no matter the value of the percentage.


Example from SampleAppLite application:

1. Create a report with 3 columns.
Example : Product, Office, Test Percent
2. For column Test Percent, use formula : ("Base Facts"."Target
Revenue"/"Base Facts"."Revenue")*100
3. For column Test Percent, set Column Properties > Data Format > Override
Default Data Format > Treat Number As = Percentage
4. Create a bar graph view with
Group By (Horizontal Axis) = Product
Bars (Vertical Axis 1) =Test percent
Graph Prompts = Office
5. Click Graph Properties > Style > Style and Conditional Formatting >
Conditional Formatting

Add a condition :
Target Revenue / Revenue is greater than or equal to 70 (set to any
reasonable value based on your data) > Select a different color.

6. Run the report and verify that the colors show up correctly
7. Make the following 2 changes and save the report with a different name:
Edit formula : ("Base Facts"."Target Revenue"/"Base Facts"."Revenue")
Column Properties > Data Format > check Scale for % (x 100)
8. Run the report and notice the Conditional Formatting is not applied.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.