Forum Discussion
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 representaion. My chart X axis should be dynamic categories where i cannot hard code the 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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
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
prakash11440278Hi 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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
