cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ValubiMartin Senior Member
Senior Member

Re: Cumulative sum by month with missing months results in gaps in clustered column chart

@wdean

 

How did it go? I just want to follow up - could you replicate my work?

 

Best,

Martin

wdean Regular Visitor
Regular Visitor

Re: Cumulative sum by month with missing months results in gaps in clustered column chart

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.

 

 

Highlighted
dsahnen Frequent Visitor
Frequent Visitor

Re: Cumulative sum by month with missing months results in gaps in clustered column chart

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.CummlativeExample - Power BI Desktop.jpg