Forum Discussion

pey's avatar
pey
Frequent Visitor
5 years ago
Solved

Rearrange data table

Hi,

 

Is it possible to rearrange the subject in a customized manner apart from just via values/alphabetical order?

For instance, I would like Export of goods & Services to be the top line, followed by Export of goods, Export of services etc.

 

If such function is not available, I was thinking of creating another column in my table data and assigned each subject with a number in the order that I would like it to be presented and then sort it.

 

OR just simply add a numerical number in front of my subject (e.g. 1.0 Export of goods and services, 2.0 Export of goods and services) and then sort it in ascending order...

 

 

 

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    pey 

    you can try to create a order table, subject column order by order column. create relationship with your fact or dim table. Use the subject column from the new table in the visual.

  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi pey ,

     

    You can add a conditional column in Power Query Editor to do a custom sort on the data, like this.

     

     

    Then sort the Subject column by Order column.

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    5 years ago

    pey 

    you can try to create a order table, subject column order by order column. create relationship with your fact or dim table. Use the subject column from the new table in the visual.

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi pey ,

     

    You can add a conditional column in Power Query Editor to do a custom sort on the data, like this.

     

     

    Then sort the Subject column by Order column.

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.