Replicate Cumulative Excel Chart

[geoff_taylor3]

Good afternoon,

I am trying to replicate a stacked column chart that I have in Excel within Power BI:

The above is a running total where I am able to split out in to the different categories, above the total for the previous period.

The table that I created in Excel to create this is:

I am struggling to recreate this in Power BI using the raw data. I have been able to add in one of the lines, but I have only been able to get the columns to show either each period, or where I have managed to use a measure to create the running total, it triplicates the numbers:

Any help, greatfully received 🙂

[Anonymous]

Hi @geoff_taylor3 ,

I have found a similar post, please refer to it to see if it helps you.

Solved: Replicating Excel Chart with Data below Visual - Microsoft Power BI Community

If I have misunderstood your meaning, please provide more details and your desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.