Calculate percent by column for a line chart

[rlsmith1994]

I have a viz table that calculates column percents based of a toal:

I would like a line chart to do the same. However, the line chart in Power BI doesn't do that. The line chart only calculates percent of total of all values for all years, not by individual year. 

How do I get the line chart to calculate column percents by year?

Context

The percents in the table are based on the value column in the screenshot below. That is my data table. That column is pivoted. There are four possible values (1,2,3,4). I have a filter table set up with the text ("have not decided, plan to do," etc.). 

The Years in the line chart and table come from a different table I call demographics. The relationship between the demographics and data tables are surveyid (screenshot above). I use the demographics table to filter the data table. 

I can't believe I am the only one with this issue. I would really appreciate anyone's help with this. Thank you. 

[Ritaf1983]

Hi @rlsmith1994 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[rlsmith1994]

Got it - thanks for the advice! I will create a new post and upload sample files.

[rlsmith1994]

Link to the new post: https://community.fabric.microsoft.com/t5/Desktop/Calculate-percent-by-column-for-a-line-chart/m-p/3...