Create a pie chart where the Expenses are displayed as a % of Revenue

[ChrisAZ]

So I am going to try to explain this as clearly as possible, but essentially, I want to create a pie chart that displays the different expenses categories as a % of the total revenue value. Said another way, the "100%" value of the pie chart would be the revenue amount and then the categories would be shown a sa percent of that, with the remaining shown as "Net Revenue" or something similar. Sample data set would be like this:

So, for example, with the total revenue being the 1,270,758 in this case, we would expect that in a pie chart it would show Part cost as 11.74% (149,190/1,270,758), Labor cost as 15.94% (202,546/1,270,758), and Fuel cost as 16.26% (306,622.51/1,270,758), and the remaining as 56.06% (Total of the other percentages (43.94%) subtracted from 100%.

[ChrisAZ · Accepted solution]

I was able to get a solution here on a repost of sorts. Thanks!
https://community.fabric.microsoft.com/t5/Desktop/Create-a-pie-chart-where-the-Expenses-are-displaye...

[v-csrikanth]

Hi @ChrisAZ 

You can follow these steps in your excel.

1.Select the entire table.-->right click--> go to get data from Table/Range.

2. Ctrl+select Part Cost , Labor cost and Fuel cost. Go to Transform tab above and click on unpivot columns as shown.

If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.
 

[v-csrikanth]

Hi @ChrisAZ ,

You can follow these steps

 Unpivot Part cost, Fuel cost and Labor cost 

Then create a custom column to get % of Truck revenue

 to get cost as % of revenue

You will then have your table look  like this

Finally pull the pie-chart for desired result.

If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.

[ChrisAZ]

Pardon my ignorance, but you can tell me how I "unpivot" as described here? Thanks!

[Deku]

Create a field parameter, adding each of the cost measures. Then add to pie chart visual

[ChrisAZ]

I am sorry, can you provide more specifics on what you mean by adding a "field parameter"?