Remove variance analysis from Waterfall

[PBIMike]

Hello,

I'm trying to use a waterfall to bridge sales by sub-category (eg. new/lost customers) across 2018 / 2019 / 2020. I want all waterfall movements to impact a cumulative value across all years (our revenue is annual recurring, and so should not reset to nil at the start of each year), not as year-on-year variances:

eg.

2019 New customers = £3m

2020 New customers = £5m

Current waterfall = £2m increase

Desired waterfall = £5m increase

How do I turn off this net movement waterfall effect?

Many thanks,

Mike

[Anonymous]

HI @PBIMike,

Nope, I don't think you can do customize or turn off this basic analytics mechanism of waterfall visual.
I'd like to suggest you check the appsource market if any custom visual meets your requirement or try to use R/Python visual to manually plot this graph.
Regards,

Xiaoxin Sheng

[negi007]

@PBIMikeAs per my understanding you want to show the cumulative total of all years in your waterfall chart. You can do this, you would need to create a calculated measure to calculate running total. You can do this by right clicking on your new customer revenue column then add new quick measure. 

[PBIMike]

Thank you for this. However you'll see below this is still only showing differences. The 100% variance of "START" for 2019 also remains:

[Pragati11]

Hi @PBIMike ,

Can you please some sample data ans screenshots around the waterfall chart you have got and how you want it to be modified?

Thanks,

Pragati