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