Hi @ValubiMartin. Appreciate all your efforts. I could not get your soultion to work. Even used your pbix. I think the issue was I did not have a date and artifically created one. I worked around the issue by using sql server. Much thanks for you effort.
I also faced the same problem. I was finding it difficult to follow the advice given from several locations to produce the desired result. However, by downloading your pbi file, I was able to play with the data in such a way to educate myself. I was able to create the desired result (a stacked area chart) with my data. I'm sure others will be able to do the same.