Showing results for 
Search instead for 
Did you mean: 
Resolver I
Resolver I

Water Fall Chart - changing Current Year and Prior Year Sort Order - Includes video and demo .pbix

Hello PBI Community Good Day


What I'm trying to accomplish:


Video and Demo .PBIX see below.




Community Support
Community Support


Due to security reason, it is not recommended to share you entire working pbix. You may create a sample pbix tables without sensitive data and include only the required tables and dax. This helps community users to understand your situation, throw an whole pbix model is unlike to get responses.


However, I had a quick look to the pbix, if you add the product column in the table to check measure value. You can see that both tables return the same result. This is because you used the CalcID and CompID as the conditions in the SWITCH functions but they cannot be included in the visual, you probably need to make a connection between Table and Table 3 with Calendar and Product table, but I can not find an appropriate relationship can be made with existing table columns. 





Paul Zheng
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.