Forum Discussion
Creating Summary Matrix with different subcategories for Values
Hi razkosz
Please provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Regards,
Nono Chen
Hi Anonymous,
here is the file: https://drive.google.com/file/d/1ekKOJ-pXDubCeADB4hmZgYk2Dce7H_Gm/view?usp=sharing
The result I want to achieve is exactly how it is already on 1st image I provided, but the aim is to do it in smarter way. So to show different kind of values (cost, quanitity, e.g. transportatin cost, dibstribution cost, etc.) through years, projects, scenarios, etc., but to have some of these values divided into one kind of categories and other into other.
Based on my example/file it will be that: I want to show comparison of project A and B and show for them values of their Cost, Quanity of harvest, and amount of Fertalizer used, but because of some business reason, I want to show detailed Cost per each Greenhouse Type (Cold, Mix, Hot), but for Quanity of harvest, I am not carring about Greenhouse Type, but I want to show it per Product Type (Fruit, Veggie) and Fertalizer I want to see just total.