Custom Headers in matrix

[Anonymous]

Hi Friends,

Can anyone please help me how to create a matrix with custom headers.

I'm trying to replicate excel reports into Power BI.

There are few Custom Headers for measures in excel reports, need to build the same in power bi.

StateID and Distributor are Dimensions.

Ships, Intransit, Store, Godown are Measures, should come under "Stock In Hand".

CurrentMonth, PreviousMonth, Rolling6 Months and Rolling12 Months are Measures, should come under "Rates".

How to build the above matrix in Power BI.

Regards,

Pavan

[v-juanli-msft]

Hi @Anonymous

Does your dataset look like this? if not, could you show how your table structure?

col1	col2	col3	col4	col5	col6	mes1	mes2	mes3	mes4	mes5
StateID	Distributor	Ships	Intransit	Store	Godown	CurrentMonth	PreviousMonth	Rolling6 Months	Rolling12 Months

I'm afraid in this case it is not possible to get the matrix as you required, we must make some changes to the data structure (create a new table based on this table which has a different data structure), could you accept this change?

Best Regards

Maggie

[Anonymous]

Hi,

Thanks for your quick reply.

Actually datasource is SQL and can't share the screenshot, and can't change the data structure also.

Can you please suggest any other way to acheive this in power bi.

Thanks In Advance.

[v-juanli-msft]

Hi @Anonymous

Do you import the data to power bi or use direct query?

If you use import mode, we can make change within powre bi.

Best regards

Maggie

[Anonymous]

Hi,

I'm importing the data from SQL to Power BI.

Can you please let me know the process to achieve.

Thanks in Advance.

Regards,

Pavan.