topic Re: I want to see the overall positive and negative change instead of just the overall net change? in DAX Commands and Tips

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

afaro — Sat, 18 May 2024 01:26:36 GMT

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.

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

xifeng_L — Sat, 18 May 2024 04:38:38 GMT

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.pbix

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

Thank you~

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

tharunkumarRTK — Sat, 18 May 2024 07:08:27 GMT

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

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

afaro — Sat, 18 May 2024 07:46:03 GMT

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.

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

tharunkumarRTK — Sat, 18 May 2024 10:14:24 GMT

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

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

Anonymous — Mon, 20 May 2024 06:56:05 GMT

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.

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

afaro — Tue, 21 May 2024 16:49:55 GMT

This is amazing. Thank you so much!

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

afaro — Tue, 21 May 2024 18:36:15 GMT

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

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

xifeng_L — Wed, 22 May 2024 09:08:25 GMT

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