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
Guidance on how to sum columns in matrix for waterfall payment report
Hi, I am working on a report that shows payments over time collected for a specific charge month. For example, in the screenshot below I have a row for charges posted in the month of January and the columns are showing months out from charge post. I would like to have the values for months out from 0-12 be cumulative instead of showing how how much in payments was collected each month. Any help is appreciated. Thank you.Waterfall chart with Top N / Bottom N sales based on slicer
Dear PowerBI Community, Despite having checked multiple threads on applicable DAX formula’s I can’t seem to find the correct solution for what I’m searching for. I would greatly appreciate it if someone could help me. For a data source, I have a single dataset of customer names, time periods and sales values. I want to setup a waterfall chart whereby between the totals, I want to show the top-5 gainers in sales, top-5 declines in sales and have the sales change of all other customers grouped together in ‘Others’. I verified that this can only be achieved using DAX formulas (i.e. not with just visualisation options). The thing that complicates this is that I have a slicer whereby the user can select any (2 or more) time periods, so the DAX formula needs to be dynamic to accommodate any combination of time periods. Would appreciate any DAX help.
