Forum Discussion
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!
- Anonymous7 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
- AnonymousNot 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: