How to show waterfall show at month level

[mohitgup20]

Hi All,

I am trying to migrate a visual from Tableau to PowerBI, but not able to replicate the same. Need your help and expert advice

Currently the visual in Tableau is:

When trying to replicate it in PowerBI, the visual look like:

So the current problem statement is how to fix the gap value column as its starting for 0 in x-axis and secondly in column chart if we have more the one measure not able to apply conditional formatting where I need if the sum of gap is positive the green else red.

@v-cgao-msft @parry2k  @amitchandak @Ritaf1983 @lbendlin @Ahmedx 

[danextian · Accepted solution]

Hi @mohitgup20 

By the looks of it, what you want is to have a waterfall that resets every month, not cumulative which is what a waterfall does. There isn't an out of the box way to do that. You will need to use some advanced DAX and a disconnected table. It's hard to explain how it is done so please play around with the attached pbix.

[Ritaf1983]

Hi @mohitgup20 

It seems like a waterfall with subtotals, take a look at the linked tutorial:

https://www.youtube.com/watch?v=EvrzytETi20

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly