4 Replies Latest reply on Jun 29, 2016 11:19 PM by Allen Qin

Add both measure values and percentage difference to side-by-side bar charts

I have the following side-by-side bar charts.

Is there a way to add both the measure values and the percentage difference(in red box) on top of the bars?

I've attached the sample workbook.

Thank you for your help.

• 1. Re: Add both measure values and percentage difference to side-by-side bar charts

Hi Allen,

you can do it as follows.

Create a simple bar chart. Add actual values in the label.

Then add the same measure in the column and create a table calc as below.

Drag it to the label shelf. (Don't press control) and Adjust you label text as below.

You will get the result. Please refer to the below screenshot to confirm the result.

Unable to upload the file due to internet. I will upload once speed is good.

Thanks and Regards,

Ashish Chaudhari

• 2. Re: Add both measure values and percentage difference to side-by-side bar charts

Hi Allen,

used this

prepare

(ZN(SUM([Profit])) - LOOKUP(ZN(SUM([Profit])), -1)) / ABS(LOOKUP(ZN(SUM([Profit])), -1))

(ZN(SUM([Quantity])) - LOOKUP(ZN(SUM([Quantity])), -1)) / ABS(LOOKUP(ZN(SUM([Quantity])), -1))

(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))

• 4. Re: Add both measure values and percentage difference to side-by-side bar charts

Hi Ashish,

Thanks for your reply. I can't find the screenshot you mentioned. Can you please upload your workbook or detailed steps and screenshots when you get a chance?

Thanks,

Allen