custom values on data points in bar chart

[#1]

Hi all,

i have stacked bar chart for different kpi's.each kpi have weight.so i want show height accordingly with the weight of kpi.

ex:i have TQR,OOR,PPR kpi's.5,5,6 are corrsponding weights. so i am multipling  expresion with weights.so far it is fine .but i want show values on data points for each stack with out weight .but default values on data points is value of expression.is there any way so that i can divide the weight and show only normal value in data points.

please suggest a solution.

thanks in advance..

[giakoum]

You can create a new expression without weight, and check "Text on axis" and un check everything else.

It is not on data points but it is as close as you can get.

Of course you could also create a custom expression that will show on mouse over, but i am not sure if this is what you need

[#3]

this is giving value on axis ,but i need values on each stack of bar

[giakoum]

not possible

And not a good idea I think. Will not your users be confused if the axis shows a different number that the value on data point?

[#5]

is there any tricky way i can get values

[giakoum]

not that I know off

unless you want to create text in chart with the values or an overlapping chart

both are not good ideas as the chart changes according to selections

[#7]

that is requirement from user only.they need in that way and want  y-axis to be hidden

[#8]

what about the option 'Values on Data Points'.

[giakoum]

Charan is asking for values from a different expression

[kuba_michalik · Accepted solution]

You can try making your expression into a Dual() - make the text part (first) from value of KPI without weigths, and the numeric value (second) as your current expression. Example attached (chart on the right is for comparison, so you can see it works)