facing matrix column and row value issue

Question

I have one table in that table i have four columnColumn IdColumn SalesColumn ProfitColumn PeriodFilter-Reporting Period&nbsp;Using matrix chart I put the following columnRows=IdColumns=PeriodValues=Sales,Profit&nbsp;&nbsp;&nbsp;&nbsp;Original DataId&nbsp;&nbsp; Sales Profit&nbsp;&nbsp;&nbsp;Period&nbsp; Reporting Period1&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; 101&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18-Mar1&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp; 201&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18-Apr1&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp; &nbsp;301&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20151&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp; 401&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20162&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp; 501&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20173&nbsp;&nbsp;&nbsp;&nbsp;60&nbsp;&nbsp;&nbsp;&nbsp; 601&nbsp;&nbsp;&nbsp;&nbsp; 2018&nbsp;Expected OutputId&nbsp;&nbsp; Sales&nbsp;&nbsp;2013&nbsp;&nbsp; 2014&nbsp;&nbsp; 2015&nbsp; 2016&nbsp;&nbsp; 2017&nbsp; 2018&nbsp;&nbsp; Reprting Period&nbsp;1&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 101&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;201&nbsp;&nbsp;&nbsp; &nbsp;301&nbsp;&nbsp;&nbsp;&nbsp; 401&nbsp;&nbsp;&nbsp; &nbsp;-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18-Apr&nbsp;Current OutputId&nbsp;&nbsp;&nbsp;Sales&nbsp; 2013&nbsp;&nbsp; 2014&nbsp;&nbsp; 2015&nbsp;&nbsp; 2016&nbsp;&nbsp; 2017&nbsp;&nbsp;2018&nbsp;&nbsp; Reprting Period&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10&nbsp;&nbsp;&nbsp;&nbsp; 101&nbsp;&nbsp;&nbsp;&nbsp;201&nbsp;&nbsp;&nbsp;&nbsp; 301&nbsp;&nbsp;&nbsp;&nbsp;401&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18-Apr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40

anonymous · Answer

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

&nbsp;
Regards,
Xiaoxin Sheng

anonymous · Answer

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.&nbsp;Request you to please us with the same.

anonymous · Answer

Hi&nbsp;Anonymous,
&nbsp;
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.
&nbsp;
Regards,
Xiaoxin Sheng

anonymous · Answer

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

anonymous · Answer

Hi&nbsp;Anonymous,
&nbsp;
Nope, measure can't use on row fields as category label.
&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

facing matrix column and row value issue

5 Replies

Related content

Matrix Column Widths

Matrix column based on other matrix columns

Matrix column not grouped

Matrix table column Hide

Facing challenge to calculate previous year QTD