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.
Hi,
is there any way to get statistical values at the end rows of matrix table? For example, i have matrix with dimensions in rows and at the end of these values i want to get additional options for statistical values.
Like at the picture:
Maybe there is a way to show measurements as dimensions?
I tried with "if" function. It worked but it is to complex for bigger data.
I looked up for custom visuals, but there is no visualisation, that could do that.
Maybe there is another way or existing visual?
Hello,
You can put your min, max, sum, avg, sd, ... in a separate card visual, modify its title and formatting and display it at the end of your matrix.
As far as I know, there is no summary table.
I'm curious to know how you did it with an IF condition and append it to the table?
Sorry for late response 🙂
For summary with if function i had to create a new table with coppied dimensions in first column, (lets call it simple "Table").
I that column i coppied dimensions from original table in first columne "Category" (for example dimensions 1 to 5) and added two additional dimensions (Dimension 6: Sum; Dimension 7: Average ).
In the second column ("Values") I writed values:
Then I connected new table to table with original dimensions.
Then I created formula 3 formulas,
The last formula was with IF:
Ifformula:=if(
max(Table[Values])=1;[Sum];if(
max(Table[Values])=2;[Average];
[Calculation]))
In Power BI then I created matrix visualisation with categories from created table (With name "Table" :)) and with IF formula.
I am not sure if this formula is perfectly correct, but i hope you get the idea. This way of using IF also works for calculating values between rows. However, it has many problems:
Greetings,
Matej
Vote for summary tables here:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13242426-add-summary-to-table-mat...
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 |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |