Display Column data as rows

[ffzhang2396]

Hi everyone,

I have run into an issue with displaying data in a certain way on powerBI. I have several columns of boolean data type with the column headers being the type i want to display by. However, I am unable to get the column headers to display as rows with the count of the number of TRUE for that column. I have included some example data and expected output below.

My table looks like this:

When I try to create a table with this data, the output is this:

However, I want to display the table like such:

I have tried to use a matrix to display the data, but it does not let me sort by Types or by number of True.

Any help is appreciated!

[Anonymous · Accepted solution]

I've achieved this by:

-unpivoting all the colums, creating this:

then in a table or matrix with a visual filter for TRUE, I created this: