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.
Is it possible to change the row "Total" which sums up each column, to variance, median, mean, etc.
I'm trying to visualise budgeted sales to actual sales and instead of seeing the sumation of these I would ideally like to see the variation to budget or even the average.
Is this possible?
Solved! Go to Solution.
@HLST
The "total" doesn't really mean sum up the values, it is just a label that display of the aggregation of visual value. For example, if I want it to be AVERAGE, I can create an measure = average([value]), and change the label from "Total" to "Average" under the "subtotals" section in the format panel. This also applies to variance, mean, median, etc. You need to create an appropriate measure and change the label accordingly.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@HLST
The "total" doesn't really mean sum up the values, it is just a label that display of the aggregation of visual value. For example, if I want it to be AVERAGE, I can create an measure = average([value]), and change the label from "Total" to "Average" under the "subtotals" section in the format panel. This also applies to variance, mean, median, etc. You need to create an appropriate measure and change the label accordingly.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Are you able to share what your fields look like in this case?
I am still a little unclear on how to change the Column totaal values to variance or average without using code.
@HLST ,isinscope can help
I think you need use column on column of matrix
If(isinscope(Table[COlumn]), [Budget], [Variance])
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |