Sort string of number in chart

[Anonymous]

Hi everyone,

In my table, there is data for example like this: Group 1, Group 2, Group 3, Group 10, Group 20, Group 100...

When I create a chart to show these groups, the chart displays in the order Group 1, Group 10, Group 100, Group 2...

Is there a way to show the group in the order of number?

Thank you

[Anonymous · Accepted solution]

You can add another sorting item in the table. Below is an example regarding how to sort weeks. You can use it as a reference for sorting groups.

For the Weeksort, use number for ordering and make sure the column type of Weeksort is Number in Power B. Select the Week column, click Modeling > Sort by Column and then choose sort by Weeksort. After that, you should get the order to sort by (Week 1, Week 2 etc)

[Anonymous]

Thank Jessica