Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
Running into an issue in creating a waterfall visualization. I'm trying to create a waterfall with a starting and ending EBITDA and the variance displayed as breakdown staking. However I'm running into an issue where random blank columns with the exact variance between the Category values appear. This makes the waterfall unusable and I can't understand what is going on.
As you can see below blanks appear with the variance between the Category appear.
I've set up the starting and ending EBITDA values and EBITDA drivers as seperate tables with a one to many relationship to the table that contains the variance values linked by driver name, I have the variance values as Y-Axis and the Category as EBIDA driver Breakdown as Non-EBITDA
Those blank values do not exist anywhere in the tables and what is stranger is that when I remove the blanks via filtering the waterfall removes all data from the visualization. Or if I remove it for EBITDA for instance, only the blanks for driver are shown.
I've been at this for several hours and cannot determine where I've gone wrong.
How are these two tables wired in the data model?
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.