I want to see the overall positive and negative change instead of just the overall net change?

[afaro]

Product	Market Value	Date
A	30	12 June 2024
B	40	12 June 2024
A	10	13 June 2024
B	50	13 June 2024
A	50	14 June 2024
B	70	14 June 2024

In this example, I would like to see a chart with dates on the X axis and on the y axis, 

I would see for 13 June 2024, 1 bar of +10 (B increased by +10) and 1 bar of -20(A decreased by 20) and then for 14 June 2024, one bar of +60(A increased by +40 and B increased by +20) and no negative bars. I don't care about the individual products, just the positive and negative changes per date shown separate instead of seeing overall net change. 

[Anonymous]

Hi @afaro 

@tharunkumarRTK @xifeng_L Thank you very much for your prompt reply and here allow me to share some of it.

I think the point is that you need to add an index column. Here I have added sorted values based on date. Create a column:

Rank = 
RANKX(
    'Table', 
    CALCULATE(
        MIN('Table'[Date]), 
        FILTER(
            ALL('Table'), 
            'Table'[Date] = EARLIER('Table'[Date])
        )
    ),
    , 
    ASC, 
    Dense
)

Then create a measure.

Measure = 
var CurrentTotal = 
    CALCULATE(
        SUM('Table'[Market Value]), 
        FILTER(
            ALL('Table'), 
            'Table'[Date] = MAX('Table'[Date])
        )
    )
var Total = 
    CALCULATE(
        SUM('Table'[Market Value]), 
        FILTER(
            ALL('Table'), 
            'Table'[Rank] = MAX('Table'[Rank]) - 1
        )
    )
RETURN
CurrentTotal - Total

Create a waterfall chart, and here is the result.

 

Regards,

Nono Chen

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

[tharunkumarRTK]

@afaro 

You can use waterfall chart 

 Here is the sample file: https://drive.google.com/file/d/1qHN2D4MXCcQZW5733quIocvhbzHVMbe6/view?usp=sharing

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[afaro]

This doesn't solve my problem as the number of products I have is huge. I am only concerned about overall positive and overall negative change that makes up the overall net change irrespective of the product. 

[tharunkumarRTK]

@afaro 
Ok,  You can find the updated file here: https://drive.google.com/file/d/11L0FoFKTkOT5JG-uZE3WvAE4Ehh9MFU9/view?usp=share_link

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[xifeng_L · Accepted solution]

Hi @afaro ,

Is this what you want?

Demo - I want to see the overall positive and negative change instead of just the overall net change...

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[afaro]

It works well, however, there is an added requirement that I wanted to fulfill. I noticed that this solution doesn't allow me to add more than one measure on a stackedcolumn chart with the legend. Is there a way to build on this solution to do that? 
@xifeng_L 

[xifeng_L]

In order to fulfil your previous requirements, need to be use the legend filed, so it is not possible to continue to add measures.

But you can create a field parameter to toggle the measure, which should also work for your analytics needs

[afaro]

This is amazing. Thank you so much!