Forum Discussion
Merge data from 2 matrix into 1 like Excel
So I have a matrix in Power BI that contains Date column in rows and city names in colum. I have another matrix grid in Power BI just below the Date vs City names matrix in power bi contains sum of all values under every city for all dates. Below this, I have another matrix, this time it contains average of all values under every city.
Problem is I want to display in same matrix grid and not in different matrix like this in excel given below.
Hi Anonymous,
In Power BI, we are not able to add any rows at the end of the matrix to calculate aggregated values currently. Any column or measure placed in VAlues property will be grouped by Row group and column group and display inside of the matrix, rather than in a new row. For your requirement, you can vote on this similar idea: Add summary to table/matrix.
Best Regards,
Qiuyun Yu
1 Reply
v-qiuyu-msftCommunity Support
Hi Anonymous,
In Power BI, we are not able to add any rows at the end of the matrix to calculate aggregated values currently. Any column or measure placed in VAlues property will be grouped by Row group and column group and display inside of the matrix, rather than in a new row. For your requirement, you can vote on this similar idea: Add summary to table/matrix.
Best Regards,
Qiuyun Yu