Forum Discussion

Firas_Belgouthi's avatar
Firas_Belgouthi
Regular Visitor
1 year ago

MATRICE FORMAT

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 ?

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    1 year ago

    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

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.