How to customize the matrix visual in power bi

[Anonymous]

Hi All,

I have a task that requires me to create a summary sheet in matrix viual in Power Bi Desktop. The problem is that the summary that needs to be created has a lot of merge columns, and I can't seem to find a way to do it. If anyone has had a similar experience, please assist me:

so far below table is what i could able to achieve:

[Anonymous]

Hi @amitchandak ,

Thank you for your prompt response. Curbal video was more relevant to me, though I couldn't save the excel file in the same environment for sharepoint. Because the dataset is from Salesforce and I do not have permanent access to it. Is there any way we can achieve desier look with some other custom visual or so?

[amitchandak]

@Anonymous , Refer these feature of using excel in app can help

Power bi Excel for P&L , add in app
Curbal
https://www.youtube.com/watch?v=IISYzTaIyu4
Guyinacube
https://www.youtube.com/watch?v=1yJnmZRTNZg