Forum Discussion

Priyak's avatar
Priyak
New Member
8 years ago

facing matrix column and row value issue

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=P...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        Anonymous
        Not applicable
        8 years ago

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