cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
asaboor Frequent Visitor
Frequent Visitor

custom excel like formating in power BI

Hi, 

Need to achieve   formating as attached just like excel sheet

 

 

pl.jpgThanks

A.Saboor

what'sapp :- +92-331-5058253

Skype: abdus.saboor.ahmad

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: custom excel like formating in power BI

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
asaboor Frequent Visitor
Frequent Visitor

Re: custom excel like formating in power BI

@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

asaboor Frequent Visitor
Frequent Visitor

Re: custom excel like formating in power BI

@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

Community Support Team
Community Support Team

Re: custom excel like formating in power BI

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

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