Obtain % Line Y-axis based on each column instead of from total

[Bullmasta]

Hi all, 

I am trying to figure out if its possible to obtain in a Line and Stacked column chart, to have the line y-axis appearing as %, but as % from the total of each different column instead of from the total of the whole many columns.

As how i see it right now, i have few columns representing a month, split in 3 categories each column (for this example will filter just 1 category). 

The y-lines should represent 2 conditions. So red one will always be above black one, and also red line technically should be close to 100%. 

if i swap the line to represent % from the total instead of no calculation, it will suddenlt drop since its not taking into consideration each column separately, but the sum of the whole. 

Basically red line is total items completed in 1 month or less, and black line items completed in 2 weeks or less.

So red should always be above the black since 2 weeks items will be included inside sum of 1 month one. 

As an example, if i have 1000 items across the year, but 100 only in 1 month. 80 items done in 1 month or less, and 20 items done in 2 weeks or less... lines as normal will display accordingly, being one line in the 20 and the other in the 80, leaving 20 items completed after 1 month.

So it should mean that from 80% of the items were completed in 1 month or less (so wont be close to the top, but close enoug because 20% of items were longer than 1 month). 

But, instead of 80%, since its from the total, will take 80 completed out of 1000, so it will display 8%. which is "wrong". 

Not sure if i explained good enought what i try to say. Hopefully someone followed 😄 

I am unsure if its possible to make any change in Powerquery or DAX in order to force the % to consider each column separately instead of the total sum of all columns. 

thanks in advance!

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...