Forum Discussion

ffzhang2396's avatar
ffzhang2396
Regular Visitor
7 years ago
Solved

Display Column data as rows

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's avatar
    Anonymous
    7 years ago

    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:

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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: