Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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.
Solved! Go to 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |