cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Static Pie/Donut Chart Legend

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. Example.JPG

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.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

You could try the following in Edit Queries:

 

Select ME, QE, MR, PC, TL -> Transform - > Unpivot Columns -> Only seclected columns. 

Pie_1.png

Once you do this, you will get the following:

 

Pie_2.png

Then you can use the Atrribute column as Legend in your pie chart. Hope this helps!

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

You could try the following in Edit Queries:

 

Select ME, QE, MR, PC, TL -> Transform - > Unpivot Columns -> Only seclected columns. 

Pie_1.png

Once you do this, you will get the following:

 

Pie_2.png

Then you can use the Atrribute column as Legend in your pie chart. Hope this helps!

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.