How to make my P&L Table display Rev follow by COGS and Exp ?

[Paulyeo11]

Hi All

https://www.dropbox.com/s/h0c450acefx3mro/GL_%20TDS%20v0001.pbix?dl=0

[v-shex-msft · Accepted solution]

Hi @Paulyeo11,

Do you mean to sort your records based on specific sorting order instead of ascii code?
If this is a case, you can refer to the following blog to build a custom sort table with 'sort by column' feature to achieve your requirement.

Custom Sorting in Power BI 

Regards,

Xiaoxin Sheng

[Paulyeo11]

Hi Sir

Thank you for sharing with me the link , it is very helpful.

Paul Yeo