Export data of Matrix table PowerBI Visual in excel with same format

[MayurUshir]

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.....

[danielpiotro]

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? 

[Anonymous]

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