Forum Discussion
SDVN
Helper I
Helper IHelp to show the completion status
I have the data in the below format and I want to show the How many projects are there in each stage. If the stage one is "Completed" then the project in in stage 2, if shage 2 is completed, it means...
mdaatifraza5556
Super User
Super UserHi 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.