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.
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.
Solved! Go to Solution.
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
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
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 |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |