Hi everyone,
So I have something similar to the table of the image below which is pushing its data onto Power BI. So I have a number of different Projects (e.g. Assignment 1, Assignment 2, etc..) with a number of different tasks (Question 1, Question 2, etc..) [Each project doesn't necessarily always have the same number of tasks].
So I made a column ('Project Status'), which basically sees if all the tasks that fall within that project are either:
- Not Started (which is generated if all the tasks are 0% in the 'Completion' column) ,
- In Progress (which is generated if at least one task is greater than 0% in the 'Completion' column) , or
- Completed (which is generated if all the tasks are 100% in the 'Completion' column)
I am thinking of having a donut chart (if you can think of a better more efficient way please feel free to share) that represents the project status to see if the project falls under one of these 3 statuses. So for example in this case, a donut chart stating 'Not Started - 1', 'In Progress - 1' and 'Completed - 1'. When trying to do this, it is counting and summing all the rows [giving me a task representation and not a project], and if I were to use count (distinct) if I have multiple projects with the same status it will only count one and take one of the status into consideration.
Any ideas how I could do this please?
Thank you in advance.
1 ACCEPTED SOLUTION
Hi @Miguelgm28 ,
According to your description, you want to show the [Project Status] as the Legand on the donut visual.
And the Value is the distinct count of the [Project] if it is this [Project Status].
If this , I think you just need to put the fields on the visual and when you have multiple projects with the same [Project Status],it shall always work in my understand.
My test data is this:
When I put the fields on the visual , the result is as follows:
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Miguelgm28 ,
According to your description, you want to show the [Project Status] as the Legand on the donut visual.
And the Value is the distinct count of the [Project] if it is this [Project Status].
If this , I think you just need to put the fields on the visual and when you have multiple projects with the same [Project Status],it shall always work in my understand.
My test data is this:
When I put the fields on the visual , the result is as follows:
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
