Current Year data & Previous Year data in between running total representation in Waterfall chart

[prakash11440278]

Hi Power BI Experts,

How to acheive the below waterfall chart in Power BI. I know there is a limitation in waterfall chart where we cannot show start & end values and in b/w running total representaion. My chart X axis should be dynamic categories where i cannot hard code the values. 

[amitchandak]

@prakash11440278 , one way is to use year and one more view by.

Another is two have measures

What is those Green and red in your case ?

refer if needed

https://www.youtube.com/watch?v=7DW5wD2j1xw

[prakash11440278]

Hi @amitchandak , The video not helped for me. 

Red indicates negitive values

Green indicates positive values

[Anonymous · Accepted solution]

Hi @prakash11440278 

I build a sample to help you to solve your problem.

Try this code.

Measure = 
VAR _MAXDate = MAXX(FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])&&'Table'[Date]<MAX('Table'[Date])),'Table'[Date])
VAR _DIFF = SUM('Table'[Value]) - CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Date]= _MAXDate))
RETURN
_DIFF

Result is as below.

Best Regards,
Rico Zhou

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