Filters on multiple 'count' values

[Anonymous]

Hello everyone!
I'm brand new to the Power BI world and have been watching various videos to try and broaden my knowledge of the program and its capabilities, but I seem to have crossed a situation that I can't seem to find answers for. Hoping that someone here can help me out.

I'm attempting to create a report on our monthly audits that are performed at my company. My desire is to use a donut chart to showcase the various development opportunities our group being audited missed for the previous month (i.e. CD 1: Empathy, CD 2: Recap Arrangements, CD 3: Talk Over, etc.) These fields are given either a 'Pass' or 'Fail' by our QA team in the SharePoint form, and I would like to showcase the total number of fails for each particular Call Development, allowing us to show where we may need to focus our trianing efforts for the coming month.

Thus far I've been able to create a donut chart, but each category is only providing the total number of audits that were performed across the board, as seen below with the 944 number, with each Call Development category broken up into its own even section.

I have added a filter for each of these Call Development sections, and when I open up each individual CD, I can see that there were 5 fails for CD 1 last month, which is what I want to show in the donut chart. But when I select 'Fail' as the filter, it changes every single area to 5 as you can see below.

As I mentioned above, my desire would be to see the total number of fails for each area in the donut chart (i.e. CD 1: 5 fails; CD 2: 0 fails; CD 3: 12 fails; CD 4: 8 fails; CD 5: 2 fails; CD 6: 15 fails) and have the chart appropriate showcase where our biggest area of opportunity was. Is this possible with a donut chart? Am I utilizing the Visual level filters improperly? If so, what can I use to provide the desired results in my report? I appreciate any and all help in advance!

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my test, you could refer to below steps:

Sample data:

Unpivot all columns in query editor:

Create a Donut chart and use the [Value] as slicer:

You could also download the pbix file to have a view.

Regards,

Daniel He