How to make my PNL table first row display Rev follow by COGS and Exp ?

[Paulyeo11]

Hi All

How to make the PNL display :-

first row -Revenue

Second row - COGS

Thrid row - Exp 

My PBIX file :-

https://www.dropbox.com/s/6yysmkrrkf2e5tz/C0021%20GL_%20TDS%20v0002.pbix?dl=0

[amitchandak · Accepted solution]

@Paulyeo11 , In matrix visual you have property show on row. That will move the values on Row, Try that out.

Refer for steps

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

For complex financial statement refer

https://community.powerbi.com/t5/Desktop/Traditional-Financial-Statements/td-p/7223

[Paulyeo11]

Hi All

I have create a P&L report , my question is how to make Revenue at row 1 and COGS at row 2 ?

My PBI file :-

https://www.dropbox.com/s/v4618zm3b8frbrv/C0011%20HOW%20TO%20MAKE%20REVENUE%20AT%20FIRST%20ROW%20V00...

[v-stephen-msft]

Hi @Paulyeo11 ,

You may try to click the black triangle.

Best Regards,

Stephen Tao

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

[Paulyeo11]

Hi Sir

Thank you for your sharing 

i have create a new post which have 3 row :-

https://community.powerbi.com/t5/Desktop/How-to-make-my-PNL-table-first-row-display-Rev-follow-by-CO...

Hope you can take a look

Paul

[Anonymous]

@Paulyeo11 

Click over the three ellipses which you have in top right of the table when it is selected.

after clicking over there you can sort accordingly.

[Paulyeo11]

Hi Sir

in my actual PBI File , I have many variable beside REV and COGS . Can you share with me how to using accounting setup table approach ? 

[V-lianl-msft · Accepted solution]

Hi @Paulyeo11 ,

You need to customize the sort.

Refer:https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi 

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

[amitchandak · Accepted solution]

@Paulyeo11 , In matrix visual you have property show on row. That will move the values on Row, Try that out.

Refer for steps

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

For complex financial statement refer

https://community.powerbi.com/t5/Desktop/Traditional-Financial-Statements/td-p/7223