Forum Discussion

prakash11440278's avatar
prakash11440278
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Current 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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

  • prakash11440278's avatar
    prakash11440278
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Hi amitchandak , The video not helped for me. 

    Red indicates negitive values

    Green indicates positive values

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.