Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have data in matrix visual as below format:
Location / Department | HR | IT | Finance | Admin | R&D |
Mumbai | 50 | 100 | 60 | 20 | 10 |
Delhi | 40 | 80 | 50 | 30 | 10 |
Bangalore | 25 | 90 | 40 | 20 | 15 |
Hyderabad | 30 | 70 | 30 | 10 | 12 |
Chennai | 25 | 30 | 20 | 15 | 10 |
When I was export data of matrix visual in excel I get the below format:
Location | Department | Headcount |
Mumbai | HR | 50 |
Mumbai | IT | 100 |
Mumbai | Finance | 60 |
Mumbai | Admin | 20 |
Mumbai | R&D | 10 |
Delhi | HR | 40 |
Delhi | IT | 80 |
Delhi | Finance | 50 |
Delhi | Admin | 30 |
Delhi | R&D | 10 |
Bangalore | HR | 25 |
Bangalore | IT | 90 |
Bangalore | Finance | 40 |
Bangalore | Admin | 20 |
Bangalore | R&D | 15 |
Hyderabad | HR | 30 |
Hyderabad | IT | 70 |
Hyderabad | Finance | 30 |
Hyderabad | Admin | 10 |
Hyderabad | R&D | 12 |
Chennai | HR | 25 |
Chennai | IT | 30 |
Chennai | Finance | 20 |
Chennai | Admin | 15 |
Chennai | R&D | 10 |
However, I require the same format which matrix visual have in Power BI as below:
Location / Department | HR | IT | Finance | Admin | R&D |
Mumbai | 50 | 100 | 60 | 20 | 10 |
Delhi | 40 | 80 | 50 | 30 | 10 |
Bangalore | 25 | 90 | 40 | 20 | 15 |
Hyderabad | 30 | 70 | 30 | 10 | 12 |
Chennai | 25 | 30 | 20 | 15 | 10 |
Please help me to get this result.
Solved! Go to Solution.
Hi @Seemaa ,
The exported data won't preserve the formatting in Excel when export the data of matrix visual. Please find the details in the following official documentation:
Export the data that was used to create a visualization
You can use some of the following methods as a workaround:
1. Use the exported data to create a PowerPivot table in the excel file to recreate the matrix visual in Power BI
2. Export reports to PDF from Power BI Desktop
3. Integrating Power BI Tiles into Office documents
In Power BI Service:
4. Copy a visual as an image to your clipboard
In addition, there is one request with similar needs have been posted in the Idea forum. This feature is expected to be implemented in the future, please check the links below for details.
Allow Table and Matrix Data Exports to Match PowerBI Visual
Export to Excel improvements for table and matrix visuals
Best Regards
Hi @Seemaa ,
The exported data won't preserve the formatting in Excel when export the data of matrix visual. Please find the details in the following official documentation:
Export the data that was used to create a visualization
You can use some of the following methods as a workaround:
1. Use the exported data to create a PowerPivot table in the excel file to recreate the matrix visual in Power BI
2. Export reports to PDF from Power BI Desktop
3. Integrating Power BI Tiles into Office documents
In Power BI Service:
4. Copy a visual as an image to your clipboard
In addition, there is one request with similar needs have been posted in the Idea forum. This feature is expected to be implemented in the future, please check the links below for details.
Allow Table and Matrix Data Exports to Match PowerBI Visual
Export to Excel improvements for table and matrix visuals
Best Regards
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
2 | |
2 | |
1 |