Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pie chart and I want to format the value in the expression as Percentage of total Values.
Anyway I can do that inside of the expression script?
Thxs,
Alec,
Just check the 'Relative' checkbox and percentages will be displayed.
I cannot use this option as I have a toggle to chnage the expression by user.
The only way I can do is by setting that on the script expression but I don't know how to do that.
Thxs,
In this case, try:
num(sum(Value)/sum(total Value), '#,##0%')
Hi,
Thanks for the replay .
Logic is correct but the field Value and Total Value are the same field.
I tried:
Num(Sum([Sales])/Sum({1}[Sales]), '#,##0%')
But I got 100% on on all values.
Thxs,
Hi,
Michael's expression should work.sum(total sales) forces the sum over all products whereas sum(sales) only computes sales for a particular product.
Regards,
Xue Bin
Hi,
Michael's expression should work.sum(total sales) forces the sum over all products whereas sum(sales) only computes sales for a particular product.
Regards,
Xue Bin
Thank you guys.
Somehow it wasn't workking yesterday. I t is working as wanted.
Regards,
Alec
Same here,
any idea why this is happening?