If you could use Matrix visual in power bi, and first of all you need to define the hierarchy of the data.
then use drill mode in matrix.
Thanks for your comments,Hierarchy means Prod -ProdCat , I used Matrix issue is related to Gross profit & NS% its calculated field revenue -previous field , as mentiond in image calculation
Thanks for your comments,Hierarchy means Prod -ProdCat (1st 2 columns). I have used Matrix ,issue is related to Gross profit & NS% its calculated field revenue -previous field [gross profit] , NS % (total revenue/Col1 like Revnue total ) , as mentiond in image calculation
For Net incomes/EBITDA/Adjusted EBITDA may difficult appear in the one visual with other attribute.
Your format is a custom format, there is no similar visual could be used for now.
They are summary calculation, I suggest you put them in different visual separately.