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

Helper IV

## DAX for Remaining Percent Left and Reflect in Bar Graph

Hi Power BI Experts. I would like to ask your help please for my bar chart in the bottom.

I want to to reflect in the bottom bar chart the remaining percent left. As you can see in the upper bar chart it is more than 100% (in my chart I use decimal) which 1. 4.

I want to reflect the in the bottom chart that the remaining  percent left is -40% (or -0.4). As you can see, only the 40% in the upper chart is subtracted to 100%. The bottom chart should supposed to be calculate the 100% and the 40%. In mathematical sense, the computation is

100% maximum percent - 40% percent Project A - 100% in Project B = -40%

I want to know how to put a DAX to have a result of the "Remaining Percent" column in my data so I cannot put it manually. When the end date of the project comes, it will subtract to the total assigned percent.

MonthAssigned ResourceProjectStart DateEnd DateMaximum PercentCapacity AssignedRemaining Percent

 01/07/2022 Employee A Project A 22/07/2022 31/07/2023 100% 40% 60% 01/08/2022 Employee A Project A 22/07/2022 31/07/2023 100% 40% 60% 01/09/2022 Employee A Project A 22/07/2022 31/07/2023 100% 40% 60% 01/10/2022 Employee A Project A 22/07/2022 31/07/2023 100% 40% 60% 01/11/2022 Employee A Project A 22/07/2022 31/07/2023 100% 40% 60% 01/12/2022 Employee A Project A 22/07/2022 31/07/2023 100% 40% 60% 01/01/2023 Employee A Project A 22/07/2022 31/07/2023 100% 40% 60% 01/02/2023 Employee A Project A 22/07/2022 31/07/2023 100% 40% 60% 01/03/2023 Employee A Project A 22/07/2022 31/07/2023 100% 40% 60% 01/04/2023 Employee A Project A 22/07/2022 31/07/2023 100% 40% 60% 01/05/2023 Employee A Project A 22/07/2022 31/07/2023 100% 40% 60% 01/06/2023 Employee A Project A 22/07/2022 31/07/2023 100% 40% 60% 01/07/2023 Employee A Project A 22/07/2022 31/07/2023 100% 40% 60% 01/09/2022 Employee A Project B 01/09/2022 01/09/2023 100% 100% -40% 01/10/2022 Employee A Project B 01/09/2022 01/09/2023 100% 100% -40% 01/11/2022 Employee A Project B 01/09/2022 01/09/2023 100% 100% -40% 01/12/2022 Employee A Project B 01/09/2022 01/09/2023 100% 100% -40% 01/01/2023 Employee A Project B 01/09/2022 01/09/2023 100% 100% -40% 01/02/2023 Employee A Project B 01/09/2022 01/09/2023 100% 100% -40% 01/03/2023 Employee A Project B 01/09/2022 01/09/2023 100% 100% -40% 01/04/2023 Employee A Project B 01/09/2022 01/09/2023 100% 100% -40% 01/05/2023 Employee A Project B 01/09/2022 01/09/2023 100% 100% -40% 01/06/2023 Employee A Project B 01/09/2022 01/09/2023 100% 100% -40% 01/07/2023 Employee A Project B 01/09/2022 01/09/2023 100% 100% 0% 01/08/2023 Employee A Project B 01/09/2022 01/09/2023 100% 100% 0% 01/09/2023 Employee A Project B 01/09/2022 01/09/2023 100% 100% 0%
2 REPLIES 2
Community Support

I cannot fully correlate your bar chart with the table data provided.

Best Regards,
Community Support Team _ Eason

Helper IV

Hi @v-easonf-msft  I want to see the remaining percent per month.
The scenario is there is an employee who has a project or multiple projects that has a timeline (i.e the breakdown per month)

For example: I have a project (Project A) that will run from Jan 01, 2022 up to June 30, 2022 and another project (Project B) that will run from Feb 01, 2022 until May 15, 2022. The assigned percent for the project A is 50% and for Project B is 30%. My maximum percent is 100. If I will breakdown those two projects per month, this should be the result
Jan 2022: 100% - 50% = 50%
Feb 2022- 100% -50%- 30% = 20%
March 2022: 100% -50%- 30% = 20%
April 2022:100% -50%- 30% = 20%
May 2022: 100% -50%- 30% = 20%
June 2022 : 100% - 50% = 50%

As you can see it adds and subtracts everytime there is a project starts and ends. So it checks and balance every month how many percent left. The bars in months are calendar month and not the months in the assignment table.

I hope this helps. 🙂

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.

#### Microsoft Fabric & AI Learning Hackathon

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

#### Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors