## Desktop

Highlighted
Regular Visitor
Posts: 43
Registered: ‎10-29-2018

# Stacked column chart wrong result when entering a running total in "value"

[ Edited ]

Hello everyone,

As you will see in the sample file, I want to show in a stacked column chart the running total sales and see the division by type of product (A and B).

For the "normal" facturation it works, but when I do it for running total facturation, the columns don't show the good result... The amount in February should be 240 and March should be 394 with 250 of type A and 144 of type B.

Thank you in advance for your help!

https://wetransfer.com/downloads/67414134b984dcf698dd99e0f744d26320190121162837/74959709b789be9ca070...

Accepted Solutions
Community Support Team
Posts: 2,482
Registered: ‎03-15-2018

## Re: Stacked column chart wrong result when entering a running total in "value"

Hi @DM_BI

Create a column

`month number = SWITCH([MONTH],"February",2,"March",3)`

create a measure

`Measure = CALCULATE(SUM([FACTURATION]),FILTER(ALLEXCEPT(Hoja1,Hoja1[Type]),[month number]<=MAX([month number])))`

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

All Replies
Community Support Team
Posts: 2,482
Registered: ‎03-15-2018

## Re: Stacked column chart wrong result when entering a running total in "value"

Hi @DM_BI

Create a column

`month number = SWITCH([MONTH],"February",2,"March",3)`

create a measure

`Measure = CALCULATE(SUM([FACTURATION]),FILTER(ALLEXCEPT(Hoja1,Hoja1[Type]),[month number]<=MAX([month number])))`

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regular Visitor
Posts: 43
Registered: ‎10-29-2018

## Re: Stacked column chart wrong result when entering a running total in "value"

Thank you very much, it works perfectly!

Regular Visitor
Posts: 43
Registered: ‎10-29-2018

## Re: Stacked column chart wrong result when entering a running total in "value"

Hello,

Sorry to bother you again but with this formula, my slicers don't work anymore. Do you have any solution to make my slicers work again)? They are not in the sample but I do have them and need them in my real report.

Thank you very much,

Dhania