facing matrix column and row value issue

[Priyak]

I have one table in that table i have four column

Column Id

Column Sales

Column Profit

Column Period

Filter-Reporting Period

Using matrix chart I put the following column

Rows=Id

Columns=Period

Values=Sales,Profit

Original Data

Id   Sales Profit   Period  Reporting Period

1     10    101      2013        18-Mar

1     20    201      2014        18-Apr

1     30    301      2015

1     40    401      2016

2     50    501      2017

3    60     601     2018

Expected Output

Id   Sales  2013   2014   2015  2016   2017  2018   Reprting Period

 1   10      101      201     301     401     -        -          18-Apr

Current Output

Id   Sales  2013   2014   2015   2016   2017  2018   Reprting Period

 1     10     101    201     301    401       -         -           18-Apr

        20

        30

        40

[v-shex-msft]

Hi @Priyak,

It seems like matrix works on my side, can you please share a sample pbix file which can reproduce your issue?

Regards,

Xiaoxin Sheng

[Anonymous]

Hi,

Thanks for the reply but if you see desired output is not samethere are blank values in the Id 2 and 3 for 2017 and 2018 data is coming in seperate row we would like to merge them with the 2017 and 22018 with ID 1 so that we get all the data in one single row and column in not coming under Years header.

Request you to please us with the same.

[v-shex-msft]

Hi @Anonymous,

You can drag sales column to rows field, then drill row to bottom level, then your records will summary with id, sales as category label.

Regards,

Xiaoxin Sheng

[Anonymous]

Can we add measure into the row of the matrix becuase i am not able to do the same.

[v-shex-msft]

Hi @Anonymous,

Nope, measure can't use on row fields as category label.

Regards,

Xiaoxin Sheng