cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ffzhang2396 Visitor
Visitor

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:

C8jx8WU

 

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

 

However, I want to display the table like such:

NsCnL0c

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!

1 ACCEPTED SOLUTION

Accepted Solutions
jbarnes Member
Member

Re: Display Column data as rows

I've achieved this by:

 

-unpivoting all the colums, creating this:

pic1.JPG

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

 

 

View solution in original post

1 REPLY 1
jbarnes Member
Member

Re: Display Column data as rows

I've achieved this by:

 

-unpivoting all the colums, creating this:

pic1.JPG

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

 

 

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (5,028)