Problem displaying data label in horizontal percentage chart

building reports webintelligence
1

Hi all,
I have a chart that previously displayed the data in numbers (using horizontal stacked chart). But with new request, the user want to display it using percentage. I have changed the chart type by using horizontal percent type. Also i have chnage the object format from numbers to percentage. The problem now even though it is displaying the chart in percentage, but the data value still showing numbers.
Supposely the value display in the first line for AMER is 65% for blue and 35% for orange color. Same to APJ, it should display 50% for both side instead 1 for blue & 1 for orange.
Kindly assist. Thanks much.
percentage problem.png

Didy :malaysia: (BOB member since 2009-05-07)

2

You could try
Chart | Properties | Y-axis | Values | Number format = #,##0[%]%

Mick

mikca :australia: (BOB member since 2005-12-16)

3

i’ve done that but it didnt works :oops: … So i have to do it manually. Edit my universe and create new measures that calculates the numbers in percentage. then it can display the correct numbers in % as i want.
anyway, thanks much :slight_smile:

Didy :malaysia: (BOB member since 2009-05-07)

4

Hey all,

Using R4 SP4 … had similar issue getting percentages to appear in charts.
Looked high and low… Finally stumbled into the setting in the assign data area…

Right click on chart… Assign data…. Expand the object … same place the “Hide” or “Move up”, “Move Down”

Format number is at the bottom of the menu.

awashburn (BOB member since 2012-04-10)