cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Substract of portion from Donut chart

Hello all,

perhaps the problem I'm having is so easy to solve but I'm struggling long time ago (Attaching a sample pbi for better understanding)

I have a table with real hours worked each month, those hours are classified by type (Internal, Lumpsum).

The lumpsum projects are the billable ones and the internal non billable. if the performance is 100% the chart looks like this

80% of the hours are billable and 20% are not.

Howver there is an additional columns called CV (Cost Variance) which basically tells the "trash" hours. which means I need to take those hours from out fromthe 80% billability and reduce it to a correct percentatge, the result should be looking like this if we take out 40h from the 80

the table I have has the following structure.

many thanks for the help!

Best regards

2 REPLIES 2
Resolver I

Hi @Abdel_BCN ,

I think I have the solution...

You will need 3 measures.

Measure 1 for the Total CV - Total CV = SUM(Sheet1[CV])

Measure 2 for the Total real Hours - Total Real H = SUM(Sheet1[Real h])

Measure 3 for Real Figure - Real Figure = [Total Real H] - [Total CV]

And here is the filters for the pie chart...

Hope this helped!

Many Thanks.

Taylor

Frequent Visitor

the solution does not work since i want to keep the total hours as 100h.

The only thing that should happend is to take out 40h as cost variance from the Lumpsum projects and consider them as Non billable under another type called "cost variance".

So the distribution of hours would be : 60h non billable and 40h billables

thanks.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors