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. 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.
Creating subtotals in Waterfall chart
Hi, I am trying to create a waterfall chart in PowerBI that looks something like this: However, I do not know how to assign specific categories within my dataset to act as "totals" or subtotals". I would appreciate someones advice on how to set-up my dataset and visual in Excel and powerBI, respectivelly. Thank you very much in advance, Kind regards.Budget line on waterfall chart
This is more a discussion question than something to be solved. I have been looking for ways to get a budget line into a waterfall chart. I have tried a fair number of custom charts as well as multiple forums. Bottom line Waterfall charts do not support a budget line. (would be happy to be wrong) Am I trying to utilize the chart in a way that it is just not intended to be used? It seems to me that a budget line would be useful. Of course, if the budget is 10,000,000 and the first three months total only 700,000 you have a scale issue. Thank you Bob
