Forum Discussion
prakash11440278
Post Prodigy
Post ProdigyCurrent Year data & Previous Year data in between running total representation in Waterfall chart
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 represe...
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 _DIFFResult is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
prakash11440278Post Prodigy
Post ProdigyHi amitchandak , The video not helped for me.
Red indicates negitive values
Green indicates positive values
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
_DIFFResult 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.