Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Abdel_BCN
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.

 

Abdel_BCN_0-1666722453504.jpeg

 

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

 

Abdel_BCN_2-1666722820831.png

 

the table I have has the following structure.

Abdel_BCN_3-1666722884728.png

 

many thanks for the help!

 

Best regards

 

 

 

2 REPLIES 2
TaylorPBI21
Resolver I
Resolver I

Hi @Abdel_BCN ,

 

I think I have the solution...

 

TaylorPBI21_1-1666726709474.png

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...

TaylorPBI21_2-1666726902020.png

 

Hope this helped!

 

Many Thanks.

 

Taylor

Many thank for your reply Taylor,

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.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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