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.
Could anyone help me to create a waterfall visual quarterly, please find the mockup data below:
Date---Water usage ---ID--Year
10/31/2021 | 3.2 | 10 | 2021 |
10/31/2021 | 7.1 | 10 | 2021 |
12/31/2022 | 9.1 | 20 | 2022 |
12/31/2023 | 7.8 | 30 | 2023 |
10/31/2024 | 6.2 | 40 | 2024 |
12/31/2025 | 5 | 50 | 2025 |
12/31/2026 | 5.5 | 60 | 2026 |
10/31/2027 | 6 | 70 | 2027 |
12/31/2028 | 7.2 | 80 | 2028 |
12/31/2029 | 8.1 | 90 | 2029 |
10/31/2030 | 12.5 | 100 | 2030 |
I have a Date table that we created and given the relationship between two tables by date.
Below are achieved yearly data but my requirement is:
Quarterly timeframe and for five years i.e., 20 data points excluding the first data point which is Baseline.
Any solution is very much appreciatable. 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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |