Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have following table which is a simplified example what I get if I put my data into the matrix in PBI:
Department A | Department B | Department C | Totals | |||||
Software | Done | 5 | 5 | |||||
Undone | 5 | 5 | ||||||
Machinery | Done | 3 | 1 | 4 | ||||
Undone | 3 | 1 | 4 | |||||
Totals | Done | 3 | 1 | 5 | 9 | |||
Undone | 3 | 1 | 5 | 9 |
And my second question, is it also possible that I can sort the totals on the right side asc or desc, because there is no "Sorting by Totals" in the options of that Visual.The columns are sort by ABC. Can it also be sort according to the Department with the highes Failurrate from left to right? So in this example Deparment C should be the first column followed by Department A and so fourth.
Thank you very much in advance.
Best regards.
Solved! Go to Solution.
Hi @Applicable88 ,
You could create a new table contains the departments and create a calculate column which calculate the totals for the departments(5,4,9). Then create a relationship between this table and the original table and use the department in new table for the martix instead of the department in original table. At last, sort the department by the calculate total.
Best Regards,
Jay
Hi @Applicable88 ,
You could create a new table contains the departments and create a calculate column which calculate the totals for the departments(5,4,9). Then create a relationship between this table and the original table and use the department in new table for the martix instead of the department in original table. At last, sort the department by the calculate total.
Best Regards,
Jay
@Applicable88 Why not just click the Totals column header in the matrix to sort it?
For the column sorting, maybe use a Sort By column.
The totals are the totals of every department. I know it sounds odd, but sorting according to the columns would give us quickly the department with the most failures. Since we have many columns, it does make sense. My example is also very simplified.
User | Count |
---|---|
127 | |
108 | |
100 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |