Stacked bar chart issue

[Rajkumar]

Hi All,

I am getting this error in stacked bar chart.Can anyone advise this ?

When select particular value it shows complete graph.

[Arthur_Fong]

How is your expression looks like?

[Rajkumar]

This is my expression sample

Sum(Sales)
/
Sum( total <Dim 1>Sales)

[Arthur_Fong]

Try this:

Sum(Sales)
/
Sum({1} total <Dim 1>Sales)

[Rajkumar]

Hi Arthur,

Thanks for suggestion. I don't think formula making problem here.

[Arthur_Fong]

I have tried changing the expression and here is the result.

Expression 1:

Sum([Total working minutes])/
Sum(TOTAL<Team>[Total working minutes])

Result:

Expression 2:

Sum([Total working minutes])/
Sum(TOTAL[Total working minutes])

Result:

Hope this helps.

Thanks and regards,

Arthur Fong

[Rajkumar]

Hi all,

Anyone please help this issue?

[Digvijay_Singh]

Is <Dim 1> your chart dimension?

[Rajkumar]

Yes Dim1

[Digvijay_Singh]

From error in the chart do you mean some of the bars are not adding to 100%?

Can you see how your data is different than the attached sample app I have created.

Thanks,

DJ