MATRICE FORMAT

[Firas_Belgouthi]

Hello , i want to show GROSS PROFIT under Revenue and cost of Sales in this matrix (just the view not the hierarchy) , any help please ?

[Anonymous]

Hi,

Thanks for the solution amitchandak offered, and i want to offer some more infotmation for user to refer to.

hello @Firas_Belgouthi , based on your description, you need to put the GROSS PROFIT field below the  Revenue field, and then close the “+/- icon” in row headers.

Best Regards!

Yolo Zhu

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

[amitchandak]

@Firas_Belgouthi , You can create one using calculation group , Add additional column on top of Calculation group table.

Note now calculations group can be created in Power Bi desktop

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Model explorer public preview with calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU