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.
