Help to show the completion status

Hi SDVN  - Create a new calculated column in Power BI that determines the current stage of each project.

Project Stage =
VAR Stages = {"Stage 1", "Stage 2", "Stage 3", "Stage 4", "Stage 5"}
VAR CompletedStages =
FILTER(
Stages,
SWITCH(
TRUE(),
SELECTEDVALUE('Projects'[Stage 5]) = "Completed", 5,
SELECTEDVALUE('Projects'[Stage 4]) = "Completed", 4,
SELECTEDVALUE('Projects'[Stage 3]) = "Completed", 3,
SELECTEDVALUE('Projects'[Stage 2]) = "Completed", 2,
SELECTEDVALUE('Projects'[Stage 1]) = "Completed", 1,
0
) = VALUE(RIGHT([Value],1))
)
RETURN
MAXX(CompletedStages, VALUE(RIGHT([Value],1)) + 1)

you can also count the number of projects by using measure below:

Projects per Stage =
COUNTROWS(
FILTER('Projects', 'Projects'[Project Stage] = SELECTEDVALUE('Stages'[Stage Number]))
)

Hope this helps.

Hi SDVN 

Follow the below steps :

1. Create calculated col using the below DAX.

Project_Stage =

SWITCH(TRUE(),

    'Project status'[state 2] = "", "Stage 1",

    'Project status'[stage 3] = "", "Stage 2",

    'Project status'[stage 4] = "", "Stage 3",

    "Stage 4"

)

 

2. Create a measure to count using the below DAX.

3. Use col chart ---(on x-axis put project_stage ( calculated col)   and on y axis put cnt_project) 
and here is the result

If this answers your questions. kindly mark it as a solution.

Hi SDVN 

You can use decomposition tree viusal in power bi, to get your expected output. 

Please refer below article for decomposition tree.

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-decomposition-tree

Please find my sample analysis snap below.

Thanks

Hello SDVN 

Could you please confirm if your query have been resolved the solution provided by mdaatifraza5556 ,rajendraongole1 and DineshYadl ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.If not please share the details , so that we can assist you better.

Thank you!

Hi SDVN 

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank You!