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.