Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Greetings All- I have a cumulative measure that is putting the same total on every month in my snake chart. I have 12 months (Oct -Sep) and the cumulative total at the 12th month is the only value that shows on every month. Can anyone tell me how to fix this so that it shows a rolling total for each month?
@Userpath77
Your DAX should work as long as you have SpendPlan[DATE]) and this measure is in your visual.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Fowmy----thanks for the guidance. My visual uses a seperate date table as the x-axis. This date table just has "months" and is linked to the months in my spend plan table. I have to use the date table becuase it is a combo chart using multiple sources. Any additional thoughts on how to solve?
I actually just got it to work by changing it to <=MIN. My new problem is that when I use a slicer to get a quarter, it re-starts the cumulative for whatever quarter (3 mos) I select rather than keeping the running total for that quarter. Does anyone know how to resolve?
User | Count |
---|---|
21 | |
20 | |
15 | |
10 | |
7 |
User | Count |
---|---|
28 | |
28 | |
13 | |
12 | |
12 |