Forum Discussion

prabhuk's avatar
prabhuk
Helper I
5 years ago
Solved

Matrix table

Hello, I have 3 tables namely Op Stk, Purchase, Sales and i want to create summary table as below. When i use matrix table each measurs(Op Stck, Purchase etc..) reflect in seperate column but i nee...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi prabhuk ,

     

    On the matrix options search for the option show on rows this is on the Values part of the options.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi prabhuk ,


According to your request, I simply did the following test: created 3 tables, namely OP, STK, purchase, sales. On this basis, I created a new table structure and data, as shown in the figure. Finally, the ID column is added to rows and the Data column is added to values by matrix visual, and the correct results are obtained. If there are problems, please provide comprehensive table data and information, so that I can do more detailed tests to solve your problems.

 

 

 

 

Here is the sample pbix file.

 

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.