Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
70 | |
68 | |
43 | |
34 | |
26 |
User | Count |
---|---|
86 | |
50 | |
45 | |
38 | |
38 |