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]))))
Really new to BI...I need a seprate matrix same format as above but shows me the % isnrtead of the figures for each part in each month. danextian neither of the measures work if I drop that measure into the values field of the matrix. saud968 let me look and see if your suggestion works - will feed back
Many thanks