Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I'm trying to create a waterfall chart that shows a Quarter in X-axis and the raise and fall of usage in the Yaxis,
first quarter should show the actual value of that quarter and from the next quarter onwards it should show the current - previous
Table I'm using = Sample
Date | Usage | Site Id | Site Name | Y-Q | YQRank |
22-Dec-22 | 8.68 | 81 | A | 2022-Q4 | 1 |
20-Jan-23 | 8.05 | 81 | A | 2023-Q1 | 2 |
20-Apr-23 | 5.50 | 81 | A | 2023-Q2 | 3 |
20-Jul-23 | 81 | A | 2023-Q3 | 4 | |
20-Oct-23 | 81 | A | 2023-Q4 | 5 | |
22-Dec-22 | 10.19 | 82 | B | 2022-Q4 | 1 |
20-Jan-23 | 9.26 | 82 | B | 2023-Q1 | 2 |
20-Apr-23 | 5.83 | 82 | B | 2023-Q2 | 3 |
20-Jul-23 | 82 | B | 2023-Q3 | 4 | |
20-Oct-23 | 82 | B | 2023-Q4 | 5 | |
22-Dec-22 | 8.94 | 83 | C | 2022-Q4 | 1 |
20-Jan-23 | 8.89 | 83 | C | 2023-Q1 | 2 |
20-Apr-23 | 5.27 | 83 | C | 2023-Q2 | 3 |
20-Jul-23 | 83 | C | 2023-Q3 | 4 | |
20-Oct-23 | 83 | C | 2023-Q4 | 5 |
The Dax measure which I'm using is working fine when I choose all site names, but it is not working fine when I choose a particular site (Ex: A) form the slicer.
Measure I'm currently using
Working fine when I choose all Site Names
When I select Only one site name for example 'A', It is giving wrong output as shown below.
Expected Result
When I select only 'A' The values should be
2022-Q4 = 8.68
2023-Q1 = -0.63 ----> (8.05-8.68)
2023-Q2 = -2.55 ----> (5.50-8.05)
Can some one please help me on this. Thanks in Advnse.
Solved! Go to Solution.
Hi Veena,
Try with below measure
Hi @KasireddyVeen,
Try with below measure
Hi Veena,
Try with below measure
Hi,
Thanks for the reply, it is working as expected. that was a great help.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
100 | |
98 | |
88 | |
70 |
User | Count |
---|---|
166 | |
131 | |
129 | |
102 | |
98 |