Hello, I am looking for help in creating my waterfall chart to show our MoM partner Totals with the Net Change broken out into showing the number of partners gained and the number of partners churned.
Built above using the following table:
PowerBI Waterfall Settings:
Category = Reporting Date
Breakdown = Partner Action
Y-Axis = Partner Count
Filtered so that only the "Ending partner Count" (Renamed to Net Change) is visible.
If I make the "Partners Churned" & "Partners Gained" fields visible it just shows the MoM difference for that particular attribute (ie: Gained 20 in October, Gained 14 in Novemeber... The Partners Gained shows -6. I don't need the MoM difference in that, I need to see for each month: the starting point -> Number of partners gained | Number of partners Churned -> Ending Paertner Count.
TIA for any guidance!
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
