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.
Dear all,
I am trying to create a dynamic waterfall chart allows the user to toggle between Forecast/Budget/Last Year comparing to this year Actual.
Sample as below chart.
Forecast/Budget are working fine since these categories fall into the same year.
Below is my DAX for Forecast and Budget:
My difficulty is on "Last Year", with below DAX, I can successfully fetch both current year and last year Actual in one measure
Solved! Go to Solution.
You may add CALCULATETABLE.
CALCULATETABLE ( VALUES ( Fact_Sample[Category_R] ), ALL ( 'Date' ) ),
You may add CALCULATETABLE.
CALCULATETABLE ( VALUES ( Fact_Sample[Category_R] ), ALL ( 'Date' ) ),
Thanks for the response.
In my actual case, it's a bit more complicated than the sample, since I add the other dimension (column) in the waterfall chart (which is "Segment")
But I finally achieve my expectation with the following code from your suggestion, just share if someone else might need it.
(I still not quite sure how does it works, need some more study on CALCULATETABLE)
Haha, anyone can help?
Thanks a lot!
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 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |