Forum Discussion
Showing a value and comment in matrix
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.
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.
2 Replies
ryan_mayuSuper User
here is a workaround for you in PQ. pls see the attachment below
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.