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]))))
saud968 I don't quite follow the part where you say 'replace your table amount with actual name of column'... These are my current fields selected for the matrix visual - see below. So 'my table amount' is sum of sold count. I needs the rows and columns to remain the same I just want the figures replacing with % (on a new matrix visual)...but I can't quite follow your suggestion