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.
I am currently working on getting the latest two months' data and show it on Waterfall chart.
Lets say this table is named as "Game"
Month | Name | Game | Points | Goal | Mark |
Jan-19 | Mary | Basketball | 10 | x | |
Jan-19 | Mary | Dancing | 20 | x | |
Jan-19 | Samuel | Running | 20 | x | |
Jan-19 | Samuel | Dancing | 20 | x | |
Jan-19 | Samuel | Karake | 10 | x | |
Jan-19 | Samuel | Running | 5 | x | |
Jan-19 | Rikka | Dancing | 15 | x | |
Jan-19 | Nicky | Karake | 35 | x | |
Feb-19 | Ricky | Karake | 20 | x | |
Feb-19 | Ricky | Basketball | 5 | x |
I have the data until MARCH 2019 only. I will update data in April in beginning of May. Assume it is now end of April and I
still do not have data in April
I have appended table below "Goal" into "Game" later and so that I can put goal as target in Gauge to check if the target is reached in the month or not.
Jan-19 | Dancing | 300 | ||
Jan-19 | Karake | 200 | ||
Jan-19 | Running | 400 | ||
Jan-19 | Basketball | 500 | ||
Feb-19 | Dancing | 300 | ||
Feb-19 | Karake | 200 | ||
Feb-19 | Running | 400 | ||
Feb-19 | Basketball | 500 | ||
Mar-19 | Dancing | 300 | ||
Mar-19 | Karake | 200 |
...........
Jun-19 | Running | 400 | ||
Jun-19 | Basketball | 500 |
Given by the situation, is it possible for me to look into the Waterfall Chart of March and February only at the end of April? After I update the data in May, I would expect to have Waterfall Chart of April and March, that it will always show the latest two months with points automatically after I manually update the data.
Highly appreciate if there is any DAX solution for the question. Many thanks.
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 |
---|---|
41 | |
19 | |
19 | |
15 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |