Forum Discussion
Export data of Matrix table PowerBI Visual in excel with same format
I have Matrix table in 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 Export to excel i will get 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 table in same format which Power BI Matrix Visual has like 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 |
Plese help me for getting this.....
2 Replies
Hi MayurUshir,
AFAIK, current power bi will export the underline data without any custom and styles.
For your requirement, I think the upcoming 'improve for matrix export' feature should be suitable for your requirement, the public preview version will be released in October.Export to Excel improvements for table and matrix visuals | Microsoft Docs
New and planned features for Power BI, 2021 release wave 2 | Microsoft Docs
Regards,
Xiaoxin Sheng
As this is now in public preview, do you have to do something to enable it?
If so, it is a general setting, workspace setting, or report-specific setting?
