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.
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
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))
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
