Matrix tile - custom data alignment

Question

Hello everyone,&nbsp;&nbsp;I'm working on a new project where management wants to evaluate the how a resource is being utilized on a monthly basis. They have determined that any one resource has 174 available work hours per month and supervisors assign # work hours to tasks on a monthly basis. They want to see if resources are being over or underassigned work per month.&nbsp;Data SetWorkCategoryProjectNameIdTierOrgResource RoleREsourceNameIdTaskDetailDateCommit HoursCapacity HoursProjectA252BA Resource&nbsp;85224Reporting Analyst11/1/2020150174ProjectA252BA Resource&nbsp;85224Reporting Analyst10/1/2020150174ProjectA252BA Resource&nbsp;85224Reporting Analyst9/1/2020150174ProjectA252BA Resource&nbsp;85224Reporting Analyst8/1/2020150174ProjectA252BA Resource&nbsp;85224Reporting Analyst7/1/2020150174ProjectA252BA Resource&nbsp;85224Reporting Analyst6/1/2020150174ProjectA252BA Resource&nbsp;85224Reporting Analyst5/1/2020160174&nbsp;I'm putting this into a matrix tile, results:Date7/1/2020&nbsp;8/1/2020&nbsp;9/1/2020&nbsp;10/1/2020&nbsp;11/1/2020&nbsp;12/1/2020&nbsp;Resource NameCommit HoursAvailable HoursCommit HoursAvailable HoursCommit HoursAvailable HoursCommit HoursAvailable HoursCommit HoursAvailable HoursCommit HoursAvailable HoursDutt,I150241502415024150241502415024Project150241502415024150241502415024Reporting Analyst150241502415024150241502415024Total150241502415024150241502415024&nbsp;I"m trying to get the matrix visual to appear as follows:NameWork Category7/1/20208/1/20209/1/202010/1/202011/1/202012/1/2020Dutt, ICapacity174174174174174174&nbsp;Project160160160160160160&nbsp;Total160160160160160160&nbsp;Available Hours141414141414&nbsp;Any suggestions are appreciated,&nbsp;ixdutt

greg_deckler · Answer

Anonymous&nbsp;- I have a whole recipe on utilization in my book, DAX Cookbook. It's recipe 1 in Chapter 8. Might give you some ideas.
https://github.com/gdeckler/DAXCookbook
&nbsp;

v-xuding-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Can the option of "Show on rows" help you?&nbsp;
&nbsp;

&nbsp;
The data in your expected result is not same as your original sample table. If you still need help, can you please share more details with us?
&nbsp;
&nbsp;

Forum Discussion

Matrix tile - custom data alignment

2 Replies

Related content

Customize subtotal in matrix

Matrix alignment issue

Custom Matrix Visual

Matrix Alignment as per requirement change

matrix visual value alignment

WorkCategory	ProjectNameId	TierOrg	Resource Role	REsourceNameId	TaskDetail	Date	Commit Hours	Capacity Hours
Project	A25	2	BA Resource	85224	Reporting Analyst	11/1/2020	150	174
Project	A25	2	BA Resource	85224	Reporting Analyst	10/1/2020	150	174
Project	A25	2	BA Resource	85224	Reporting Analyst	9/1/2020	150	174
Project	A25	2	BA Resource	85224	Reporting Analyst	8/1/2020	150	174
Project	A25	2	BA Resource	85224	Reporting Analyst	7/1/2020	150	174
Project	A25	2	BA Resource	85224	Reporting Analyst	6/1/2020	150	174
Project	A25	2	BA Resource	85224	Reporting Analyst	5/1/2020	160	174

Name	Work Category	7/1/2020	8/1/2020	9/1/2020	10/1/2020	11/1/2020	12/1/2020
Dutt, I	Capacity	174	174	174	174	174	174
	Project	160	160	160	160	160	160
	Total	160	160	160	160	160	160
	Available Hours	14	14	14	14	14	14