I am creating a report to show the status of multiple projects, and I'm having trouble with creating a pie/donut chart. The chart will display the status (Does Not Apply, Not Started, In Process, Complete) for each role (ME, QE, MR, PC, TL) working on the project.
When creating the pie/donut chart, I'm not sure what to use for the legend. I've tried using the ME column, but if the ME column does not contain each of the status options, this will no longer work. I've also tried creating a separate table that contains a "Statuses" column with each of the status options, but I can not get it to work. If you need more explanation I will try my best to clarify the issue. Thank you in adavance for any help you can offer.
You could try the following in Edit Queries:
Select ME, QE, MR, PC, TL -> Transform - > Unpivot Columns -> Only seclected columns.
Once you do this, you will get the following:
Then you can use the Atrribute column as Legend in your pie chart. Hope this helps!
You could try the following in Edit Queries:
Select ME, QE, MR, PC, TL -> Transform - > Unpivot Columns -> Only seclected columns.
Once you do this, you will get the following:
Then you can use the Atrribute column as Legend in your pie chart. Hope this helps!
Helpful resources
Power BI September 2023 Update
Take a look at the September 2023 Power BI update to learn more.
Exclusive opportunity for Women!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
