Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone. I am trying to figure out how to carry over data from one month to the next. I am trying to create a stacked column chart for each month that includes:
1. total payments
2. total payments actioned (approved, denied)
3. paymetns from last month that are pending
3. payments from last month that got actioned this month
Here is a sample of my data:
Month | Payments | Status |
July | 4 | P |
July | 3 | P |
July | 2 | P |
July | 7 | P |
August | 1 | A |
August | 9 | A |
August | 2 | D |
I would want to include all pending payments in July on my August bar in the stacked column chart.
Thank you in advance for your help in advance.
Hi, thanks for replying. Do you mind explaining what you mean by there's no column to establish time sequence?
Okay that makes sense. So if I make a date table will I be able to carry the data from one month to the other? If so, can you please help me with that?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |