Sort by axis values

[ek2112]

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.

[RMDNA · Accepted solution]

@ek2112,

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.

[RMDNA · Accepted solution]

@ek2112,

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.

[ek2112]

@RMDNA this looks great. Is creating Index same as creating an index column? Could you please elaborate. Thank you.

[RMDNA · Accepted solution]

@ek2112,

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.

[ek2112]

@RMDNA That worked. Thank you!