Percentage of individual column totals

[KarunwiShalom]

Hi everyone, I need help with this.

I want to create a line chart where each month shows the percentages totalling 100%. I'm working with strings and most of the solutions I've being seeing have to do with numeric data.

This is the data being shown correctly for each month

The chart above displays the data correctly but I need it in terms of percentages for each month.

The chart above is what happens when I show the values as a percentage of grand total. But, what I want is percentages for each month totalling 100%. I can't seem to figure it out.

The chart above is the original column which I have split into 3 distinct responses that I want on the chart.

The chart above is the column which is shown on the chart with the three distinct responses.

@Anonymous @Ritaf1983

[Anonymous · Accepted solution]

Hi @KarunwiShalom ,

Thanks for @lbendlin 's reply.

@KarunwiShalom This is because Line Chart uses the total number of rows in the table to calculate the percentage, if you want to calculate the percentage by the total number of rows per month, you can create a custom column, you can refer to my test for details.

divide_based_month = 1/COUNTROWS(FILTER(Table,MONTH(Table[Date])=MONTH(EARLIER(Table[Date]))))

Best regards,

Mengmeng Li

[lbendlin]

divide(countrows(table),calculate(countrows(table),removefilters(table[rating])),0)