Power BI Matrix visual table is repeating columns when adding a category column to the column field

[commercial_user]

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%

[Anonymous · Accepted solution]

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.