Show Expression as Percentage

[alec1982]

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,

[nagaiank]

Just check the 'Relative' checkbox and percentages will be displayed.

[alec1982]

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,

[Anonymous · Accepted solution]

In this case, try:

num(sum(Value)/sum(total Value), '#,##0%')

[alec1982]

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,

[#6]

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

[#7]

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

[alec1982]

Thank you guys.

Somehow it wasn't workking yesterday. I t is working as wanted.

Regards,

Alec

[ioannagr]

Same here, 

any idea why this is happening?