Forum Discussion
custom sort columns on a stacked chart
Please follow these steps.
The table with status you can create in Excel or another and add to the model.
Absolutely. You just need to create another table that will be used just for sorting.
The new table needs 2 columns. One column containing the exact values that match your statuses. The other column should be numeric and will control the sort order.
Join the column containing the statuses back to your original table. Set it to sort by the other column.
The main thing is you need to use the Status column from the new table on your axis - you can't continue to use the status column from your original table.
Does that make sense?
Absolutely. You just need to create another table that will be used just for sorting.
The new table needs 2 columns. One column containing the exact values that match your statuses. The other column should be numeric and will control the sort order.
Join the column containing the statuses back to your original table. Set it to sort by the other column.
The main thing is you need to use the Status column from the new table on your axis - you can't continue to use the status column from your original table.
Does that make sense?
Hi Phil,
Thank you for the solution.
But I do not see that it works with other vidgets. For example, if I want to create stacked bar chart, which shows in dynamics how my value is changing in terms of structure (structure = category which I put into the color coding), the function 'Sort by column' is unavailable.
Is there any solution for that vidget? Thank you in advance.