custom excel like formating in power BI

[asaboor]

Hi, 

Need to achieve   formating as attached just like excel sheet

Thanks

A.Saboor

what'sapp :- +92-331-5058253

Skype: abdus.saboor.ahmad

[v-lili6-msft]

hi, @asaboor 

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.

Best Regards,

Lin

[v-lili6-msft]

hi, @asaboor 

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.

Best Regards,

Lin

[asaboor]

@v-lili6-msft 

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

[asaboor]

@v-lili6-msft 

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