Forum Discussion
Help with Matrix Visuals Please
Hello all, I am reaching out to this community for some assistance please if someone could kindly help. I am in the process of converting a legacy report from Excel into Power BI. The repor...
Hi DeanBurston ,
Power BI and power pivot dax engine handles (consumes) the data in structured table format well, therefore, before bringing in the data in Power BI data model, it is better to unpivot the matrix format data through power query, and what's on row headers and column header in your matrix tables in Excel should be separated out in dimension tables in Power BI data model, and then relationships are created between your dimension tables and your two fact tables. You then aggregate the values' fields of your fact tables in measures, and subtract one measure from the other measure to get your required output.