Create categories based on measurements for pie chart

[Syndicate_Admin]

Hello

I have 4 measures that represent different costs: direct material costs, indirect material costs, direct labor costs, and indirect labor costs.

All measurements are calculated based on formulas according to the product and the period selected in segmenters.

The idea is to show a pie chart (cake) where the % represents each of the different costs for the selected product and period appear.

Example:

Product X and the period Jun-2022 are selected in the segmenters

The measures take the following values:

direct material costs = $20

indirect material costs = $5

direct labor costs = $50

indirect labor costs = $25

total cost = $100

The pie chart should reflect the portions of 20%, 5%, 50% and 25% respectively

[Anonymous · Accepted solution]

Hello,

you just have to put your four measurements into the pie chart Values box like this :

And the result will look like tkis