Visuals like matrix

[Anonymous]

Hello,

What would be the most suitable Visual to present the following information?

Values:

Planned Qtt

Production Qtt

Columns:

Weekday

Shift

Rows:

Machine

Product

Ideally, I would like to have a graph with Weekday and shift (by weekday) as columns headers and Machine and respective product as row headers.

Planned quantity and production qtt would be the values that I want to compare for each column (shift in weekday)/row (product in a machine).

Like the following:

		Mon	Tue	Wed	Thu	Fri
		N	M	A	N	M	A	N	M	A	N	M	A	N	M	A
Machine A	Prod. 1	100	120	110	90	90	90	100	100	100	95	95	95	110	110	80
90	130	100	88
Prod.2	120	120	120	120	120	120	120	120	120	120	120	120	120	120	120
100	105	90	93

Also, it would be perfect if I could format the background of the produced qtt: for instance, if Iproduced half of the planed qtt, half of the cell would be painted.

Thank you,

Patricia

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We can use the following measure after create several Dim Table to meet your requirement:

Value = SUMX('Qtt',SWITCH([Qtt],"Planned",CALCULATE(SUM('Table'[Planned Qtt])),"Production",CALCULATE(SUM('Table'[Production Qtt]))))

Best regards,

[Anonymous]

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,