PBI report - help needed to format when exported to excel

[ashmitp869]

Hi All,

I have a requirement where I need to export the excel file from PBI Report similar like the below image.

This export is from Qlik

I am created a similar in PBI , but I need to format the excel file similar like qlik export.

I have used matrix for this report.

When exported to excel I am getting this below.

Requirement :

1. How to keep the font and background colors in excel export.

2. Remove the EmployeeHours - this is the measures . I have rename it in visual to blank but still showing.

My matrix visual looks like this in PBI report.

[suparnababu8]

I think currently exporting with formatting seeting is not available in Power BI Matrix/Table charts.
You can refer to this for more information - https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-d...

https://learn.microsoft.com/en-us/power-platform-release-plan/2021wave2/power-bi/export-excel-improv...

[Ritaf1983 · Accepted solution]

Hi @ashmitp869 

Currently, exporting reports with formatting settings beyond a table structure is not supported.
The alternative is to export
POWER POINT / PDF
You can also build a report using a Paginated reports
Here is an initial video for introducing paginated Reports:
https://www.youtube.com/watch?v=XSIbRNXGgPQ

Or use an inforiver visuals , but they are for pay :
https://inforiver.com/blog/general/formatted-export-to-excel-spreadsheets-in-microsoft-power-bi/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly