Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Find articles, guides, information and community news

Most Recent
V-lianl-msft
Community Support
Community Support

Sometimes we want to build a waterfall chart to compare the margin between last year (hereinafter referred to as “LY”) and this year (hereinafter referred to as “TY”).  i.e. Current period (2020/10 which is selected by slicer) = 57% and prior period (2019/10) = 50%, the Diff will be 7%. To show the changes between LY and TY, we need to add LY and TY in Category Field, and add Diff in Breakdown Field. However, in our data model, it usually does not contain LY, TY and Diff directly. We need to create a category table and a breakdown table to help us build this waterfall chart.

 

 

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.