Forum Discussion
Matrix table set order for Column data in Text format
Hi dd88 ,
Based on my testing again, the task column can be sorted successfully. Try to copy the table and enter the new table.
1.Copy the Table. Enter the table data.
2.Drag the field into the matrix visual.
3.Select sort by Task steps column.
4.The result is shown below.
5.You can open the pbix file to see the detailed steps.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Anonymous
I add a new column for FeatureOrder, number format starting at 1 with next sequential number ie 1, 2, 3, etc
The result is the error message ' We can't sort by 'Feature' column by 'FeatureOrder'
The new column FeatureOrder only has 1 data value which is a number. Therefore I am not sure what the error message is referring to.
Hi dd88 ,
The Release tasks column can't have the same values. The Feature column can't have the same value. Otherwise, the sort by column feature doesn't work.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
The Feature column contains text. The FeatureOrder column contains numbers. The Feature column and FeatureOrder column do not contain the same values.Hi dd88 ,
Based on my testing again, the task column can be sorted successfully. Try to copy the table and enter the new table.
1.Copy the Table. Enter the table data.
2.Drag the field into the matrix visual.
3.Select sort by Task steps column.
4.The result is shown below.
5.You can open the pbix file to see the detailed steps.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.