Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 need all the materix in one column ("Value").
Particulars | Value |
Op Stk (From Op Stk table) | 1000 |
Purchsaes ( From Purchase table) | 2000 |
Sales (From Sales table) | 2500 |
Cl Stk (To be calculated from the above) | 500 |
Solved! Go to Solution.
Hi @prabhuk ,
On the matrix options search for the option show on rows this is on the Values part of the options.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @prabhuk ,
On the matrix options search for the option show on rows this is on the Values part of the options.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |