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.
I have a matrix control with two column settings, a "Half Year" and a "Month".
H1 H2
Jan, Feb, Mar, Apr, May, Jun, Total Jul, Aug, Sep, Oct, Nov, Dec, Total
Is it possible to show a "% of Total" value beside the Half Year totals without showing them against each month?
i.e.
H1 H2
Jan, Feb, Mar, Apr, May, Jun, Total, % of Total Jul, Aug, Sep, Oct, Nov, Dec, Total, % of Total
Solved! Go to Solution.
Hi @niallhannon ,
I'm afraid that you need to create a measure for % total and then drag it to value field in matrix.
However, it will show like this if you have two values under value fields.
Best Regards,
Cherry
% of Total = Var t = CALCULATE(sum('Table'[AMT]),ALL('Table')) var h = sum('Table'[AMT]) var tp = DIVIDE(h,t)*100 Var ret = IF(not(HASONEVALUE('Table'[Month])),tp,BLANK()) return ret
in the matrix values formating tick show on rows
Proud to be a Super User!
Hi @niallhannon ,
I'm afraid that you need to create a measure for % total and then drag it to value field in matrix.
However, it will show like this if you have two values under value fields.
Best Regards,
Cherry
If you can provide some sample data it would greatly help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
107 | |
97 | |
75 | |
63 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |