Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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:
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |