How to create 3 layer of grouping for my P&L Report ?

[admin11]

Hi All

I have a P&L Table work fine. 

But the Expense , it have about 50 items , i like to break into 5 group.

Can some one share with me how to go about it. 

I have try to create a expression , it can help me break into many group.

But i cannot combine above 2 table into 1.

My PBI file :-

https://www.dropbox.com/s/tc2bi4a3knvg93g/PBT_V2021_400%20GL_TI.pbix?dl=0

Paul

[amitchandak · Accepted solution]

@admin11 , groups can be static, which means you can create a new column using switch or dynamic based on measure and independent table

refer

https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...

Dynamic

https://youtu.be/CuczXPj0N-k