Reply
wbradshaw1990
Regular Visitor

Waterfall Visualization Displays Blanks with Exact Variance of Category Can't Remove

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. 

wbradshaw1990_1-1721315006556.png

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

wbradshaw1990_3-1721315310498.png

 

wbradshaw1990_2-1721315275184.png

 

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. 

1 REPLY 1
lbendlin
Super User
Super User

How are these two tables wired in the data model?

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)