Display another measure in pie chart breakdown

[Amit_B]

Hi,

I am using a pie chart object to show the breakdown of the number of transactions by region.
By default, the pie chart shows the share of each region (the number of transactions for each region as a percentage of the total), and I can change it to show the value (the actual number of transactions).
Is it possible to display the value of a different measure instead (average sales)?

For example:
* East -  5 transactions, total sales of 500$.
* Central - 10 transactions, total sales of 800$.
* West - 5 transactions, total sales of 300$.
The pie breakdown should be 50% for Central (10/20) and 25% for both East and West (5/20).
The average sales for each region should be displayed in each region's slice - 100$ for East (500/5), 80$ for Central (800/10), 60$ for West (300/5).

Thanks!

[rubenmarin · Accepted solution]

Hi, in the expression you can use Dual(), wich takjes 2 parameters, the first is the value shown, and the second is the number used to calculate the slice.

To show the first value you should select the last option for numeric format, in spanish it's called 'Medir Expresión', that way you can show anything you want, like a mix of text and numbers. The slice has to have enogh space to show the value.

[Amit_B]

Thanks!

I used Dual(), I just had to change the measure format as you said.