Count the number of values on each column and create a column graph

[Anonymous]

Hello, I am tasked with building a dashboard and one of the items I'm struggling to add are the scorecard items. I am trying to create a columns graph that will show the number of "Non Compliant" occurences. My database is structured roughly like this:

Score ID	Question 1	Question 2	Question 3
1234	Compliant	Compliant	Non Compliant
5678	Non Compliant	Compliant	Compliant
9012	Non Compliant	Compliant	Compliant

And so on. Each response ID links to a database of operators, along with their final score. The final objective for this graph is that I can visualize the number of non-compliant responses for each item and filter it to my needs (time-based analysis etc). I have attempted multiple techniques and none reached the final objective. I figure this would be very easy to do in Excel with pivot tables, but I'm struggling a lot to create this in Power BI. I appreciate the help.

[Fowmy]

@Anonymous 

You need to unpivot your columns to use it in Power BI for proper visualization:

Refer this this video: https://www.youtube.com/watch?v=Vff2kRBM95o

[Anonymous]

I've attempted unpivoting the columns, but it messes the IDs. It basically stacks all the responses.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Try Unpivot function to transform your table.

New Table:

Then create a Stacked bar chart visual.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Anonymous 

If you could share an Excel file with layout your have, I will be able to test it. share it through Google Drive link.