I have created Power BI report which looks like following one. I am using matrix visual to show data wherein I am showing Employees on rows and Year, Month on columns. But when I am exporting this report into excel, exported report in excel is not showing up same as matrix report however all months are also coming on rows. Is it possible to export the report exactly same as Power BI matrix report ?
There is a way if you really want to. You need make your report in one page where you can see all your data. Then export to pdf. It is okay if your font size will be small. After exporting to pdf, convert it to excel using online tool.
It requires an effort but worth it if you really need it.