Forum Discussion

ItoDiaz's avatar
ItoDiaz
Icon for Helper I rankHelper I
3 years ago

"Hacking" a waterfall chart

Hello all,    I have adapted a code that I found in the link below to do some waterfall charts : Power BI & DAX Tutorial: Waterfall charts with beginning and end states in 5 minutes - YouTube   ...
DAX
DAX SWITCH
Waterfall Chart
ItoDiaz's avatar
ItoDiaz
Icon for Helper I rankHelper I
3 years ago

Hello PiEye 

 

Thank you for your answer, I had lost hope of having one. 

 

I had already thought about to do it using a bar chart as in the old excel methods. However, I thought that it could be possible to do something directly on the waterfall chart. I was very optimistic. 

 

Your solution helps me because, it confirms that I should do it in this way and I hadn't thought about using ABS function. 

 

Unfortunately, I couldn't try your solution because my company is always delayed to distribute Power Bi releases... I'm still working with October 2022 version and Window fonction is not available!!! 

  • PiEye's avatar
    PiEye
    Icon for Resolver II rankResolver II
    3 years ago

    Hi ItoDiaz  Great news - the windows functions were actually made available before the actual release, but just weren't officially documented!

    See this blog for example (offset - one of the different window functions): https://www.purplefrogsystems.com/2022/10/previous-row-value-dax/

     

    So please try them, they might still work but the only difference will be that the intellisense will not recognise it or suggest fields / errors etc.

     

    Pi