Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Sort string of number in chart

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 th...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
Anonymous
Not applicable
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

Thank Jessica