Forum Discussion
Power BI Matrix visual table is repeating columns when adding a category column to the column field
Hello,
I have a simple table that uses measures to determine the headcount for each Business Unit by floor. Taking the measures I've created I added it to the Power BI matrix Visual. When using the drilldown page feature only the Business Unit is filtered (row values) which I realize that the Matrix was missing a column. I then added a column field that had the floor information from solution Anonymous. In its current state the drilldown report filtering works amazing when selecting a datapoint it filters by row(Business unit and by column (By floor). The issue I now have is that adding the floor information as a column created repeating columns (See fig A), Ideally I would like to have my matrix visual to look like FIG C.
The problem with Fig C is when selecting a single datapoint for the drilldown report, the filter only works by row selection (Business unit) and not the column (by Floor) because the column field (Floor Name) is missing from the matrix table. The drilldown report also will not work in a regular table visual. The limitation I see in the matrix visual is that the floor number column only has information relating to the floors and the Matrix Table doesn't allow me to add the other two columns (Total Count or Total Percent) as part of the visual so that my visual can look like Fig C.
If anyone has a fix for this please let me know!
FIG. A
| Floor 1 | Floor 2 | Floor 3 | Floor 4 | |||||||||||||||||||||
| Business Unit | Floor 1 | Floor 2 | Floor 3 | Floor 4 | Total Count | Total Percent | Floor 1 | Floor 2 | Floor 3 | Floor 4 | Total Count | Total Percent | Floor 1 | Floor 2 | Floor 3 | Floor 4 | Total Count | Total Percent | Floor 1 | Floor 2 | Floor 3 | Floor 4 | Total Count | Total Percent |
| Engineering | 20 | 10 | 20 | 150 | 200 | 31% | 20 | 10 | 20 | 150 | 200 | 31% | 20 | 10 | 20 | 150 | 200 | 31% | 20 | 10 | 20 | 150 | 200 | 31% |
| Finance | 10 | 0 | 5 | 0 | 15 | 2% | 10 | 0 | 5 | 0 | 15 | 2% | 10 | 0 | 5 | 0 | 15 | 2% | 10 | 0 | 5 | 0 | 15 | 2% |
| Marketing | 80 | 0 | 0 | 0 | 80 | 13% | 80 | 0 | 0 | 0 | 80 | 13% | 80 | 0 | 0 | 0 | 80 | 13% | 80 | 0 | 0 | 0 | 80 | 13% |
| Administration | 20 | 5 | 10 | 5 | 40 | 6% | 20 | 5 | 10 | 5 | 40 | 6% | 20 | 5 | 10 | 5 | 40 | 6% | 20 | 5 | 10 | 5 | 40 | 6% |
| Human Resources | 5 | 0 | 20 | 1 | 26 | 4% | 5 | 0 | 20 | 1 | 26 | 4% | 5 | 0 | 20 | 1 | 26 | 4% | 5 | 0 | 20 | 1 | 26 | 4% |
| Operations | 0 | 10 | 200 | 5 | 215 | 34% | 0 | 10 | 200 | 5 | 215 | 34% | 0 | 10 | 200 | 5 | 215 | 34% | 0 | 10 | 200 | 5 | 215 | 34% |
| NonClassified | 10 | 40 | 5 | 8 | 63 | 10% | 10 | 40 | 5 | 8 | 63 | 10% | 10 | 40 | 5 | 8 | 63 | 10% | 10 | 40 | 5 | 8 | 63 | 10% |
| Total | 145 | 65 | 260 | 169 | 639 | 100% | 145 | 65 | 260 | 169 | 639 | 100% | 145 | 65 | 260 | 169 | 639 | 100% | 145 | 65 | 260 | 169 | 639 | 100% |
FigB.
FIG C
| Business Unit | Floor 1 | Floor 2 | Floor 3 | Floor 4 | Total Count | Total Percent |
| Engineering | 20 | 10 | 20 | 150 | 200 | 31% |
| Finance | 10 | 0 | 5 | 0 | 15 | 2% |
| Marketing | 80 | 0 | 0 | 0 | 80 | 13% |
| Administration | 20 | 5 | 10 | 5 | 40 | 6% |
| Human Resources | 5 | 0 | 20 | 1 | 26 | 4% |
| Operations | 0 | 10 | 200 | 5 | 215 | 34% |
| NonClassified | 10 | 40 | 5 | 8 | 63 | 10% |
| Total | 145 | 65 | 260 | 169 | 639 | 100% |
Hi commercial_user
All you need to do is add the floor field to your drillthrough page.Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi commercial_user
All you need to do is add the floor field to your drillthrough page.Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.