Adding target ROW into matrix

[Anonymous]

Hello everyone

I have matrix visual and im trying to add a target as ROW in that matrix as the below image: 

Any Ideas how to create this view before the actual values? 

I have searched alot to achieve this but couldnt find any helpful results. 

Thank you in advance

[v-cgao-msft · Accepted solution]

Hi @Anonymous ,

I tried to create a simple model, please check it. If you need to sort the Taget rows, you need to create a second auxiliary column to assist in the sorting.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous]

Thank you for your efforts trying to help me.

It looks promising but im trying to adding to my model n for some reason i cant get it running, i guess its cuz i cant apply in the same way but i will try again. 

[Shaurya]

Hi @Anonymous,

I suggest you create a new row with the same columns as the table that you are using to pull the rest of the fields in your matrix. Enter the values that you want as target and then append that row to your existing table. You can create a sort column to keep your Target row on top.

Works for you? Mark this post as a solution if it does!

[Anonymous]

Thank you for your reply.

This idea was in mind and i tried to achieve it but i stuck with the column format issue, since the value of the column is number and its needed for calculation when i add <15 mins it shows as an error 😞