Showing a value and comment in matrix

[GBKYE2]

Hi all,

Does anyone know if it's possible to show a value and a comment in a matrix for a specific item?

Let's say I have this (abstracted) data:

Order	Value_Metric	Risk_Metric	Strategy_Metric	Value_Comment	Risk_Comment	Strategy_Comment
001	7	4	3	High Value	Low Risk	Not aligned
002	4	1	8	Low-Med Value	Minimal Risk	Fits Strategy

I would like to be able to select a order and show the information like this:

Order 001:

	Metric	Comment
Value	7	High Value
Risk	4	Low Risk
Strategy	3	Not Aligned

Order 002:

	Metric	Comment
Value	4	Low-Med Value
Risk	1	Minimal Risk
Strategy	8	Fits Strategy

I feel like what I'm trying to do is make a calculated table but I'm a bit stuck on how to approach this. Does anyone have any suggestions? Thanks.

[v-kaiyue-msft · Accepted solution]

Hi @GBKYE2 ,

Thank you @ryan_mayu  for your replies, allow me to provide another insight:

1. create a calculation table that combines metrics and comments into one table.

CombinedMetrics =
UNION(
SELECTCOLUMNS('Table', "Order", 'Table'[Order], "_","Value","Metric", 'Table'[Value_Metric], "Comment", [Value_Comment]),
SELECTCOLUMNS('Table', "Order", 'Table'[Order], "_","Risk","Metric", 'Table'[Risk_Metric], "Comment", [Risk_Comment]),
SELECTCOLUMNS('Table', "Order", 'Table'[Order], "_","Strategy","Metric", 'Table'[Strategy_Metric], "Comment", [Strategy_Comment])
)

2. create the slicer visual object and put the order field in.

3. create the matrix and place the fields as shown below.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

here is a workaround for you in PQ. pls see the attachment below