Forum Discussion
Create a matrix visual showing percentages
Hi, I have a matrix visual which shows amounts of parts by month, but I want to convert these amounts to % (% of the total for each month). So for June 24 Screen I want to show as 35%, June Misc ...
Anonymous This will work once you unpivot the date columns. A single measure can be used with this approach instead of creating one for each date. A sample .pbix is attached.
Percentage of Column Total =DIVIDE(SUM('Table'[Value]),CALCULATE(SUM('Table'[Value]), REMOVEFILTERS('Table'[Part]))))
you bchager that has worked 🙂