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.
I have the following table in the power bi
Name | Budget | plan | actual |
number of chicken, unit | 2 | 3 | 4 |
number of chicken, kg | 1 | 2 | 3 |
now I want to add one more row after the calculation.
I want such a table,
Name | Budget | plan | actual |
number of chicken, unit | 2 | 3 | 4 |
number of chicken, kg | 1 | 2 | 3 |
average weight chicken | 0,500 | 0,667 | 0,750 |
so the 3rd row is based on the previous 2 rows.
Is it possible to add inside the Power bi? if yes can I get some directions, please?
Hi @asap ,
Name | Budget | plan | actual |
number of chicken, unit | 2 | 3 | 4 |
number of chicken, kg | 1 | 2 | 3 |
Is the above table the data imported? Or a matrix visual/table visual?
If it's a matrix visual, it's still possible.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @asap ,
this is not possible using the default Table or Matrix visual.
Custom visuals like the Zebra BI Table visual, the Inforiver visual, and the Financial Reporting Matrix by Profitbase support "custom" total on rows and columns.
Regards,
Tom
Covering 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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |