Forum Discussion
Sort by axis values
Hi all,
Just wanted to check if there is a way to sort by y-axes for the following stacked bar chart visual. I tried sorting on the "Sort by Project Duration"
but I am not able to get the below desired result, which is to get the project duration risks in the order of severity?
High Risk 11
Moderate Risk 9
Minimal Risk 18
Empty Risk 1
Thank you for your time.
There's a variety of ways to accomplish this, but one option is creating an index for severity (either 4/high risk or 1/high risk). Once that's complete, use Modeling > Sort by Column to order the risk field by index.
Once you've done that, what you tried in your picture will be successful.
Yep, I just created an index column in the fabricated table. There's other options depending on the complexity of your data, but it looks like this should work for what you need.
If it answered your question, make sure to mark the post above as a solution to help other users with similar problems.
4 Replies
There's a variety of ways to accomplish this, but one option is creating an index for severity (either 4/high risk or 1/high risk). Once that's complete, use Modeling > Sort by Column to order the risk field by index.
Once you've done that, what you tried in your picture will be successful.
Yep, I just created an index column in the fabricated table. There's other options depending on the complexity of your data, but it looks like this should work for what you need.
If it answered your question, make sure to mark the post above as a solution to help other users with similar problems.
