Forum Discussion

geoff_taylor3's avatar
geoff_taylor3
Regular Visitor
4 years ago

Replicate Cumulative Excel Chart

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 🙂

1 Reply