If you'd like to do advanced analytics, have access to the underlying calculations with a custom version, and compare different slices of the data interactively to bubble up opportunities then keep reading.įor the purpose of this example, a linear regression trendline will be calculated using hierarchical values on a Date axis. For a metric such as Average Length of Stay, users could browse the Power BI report to compare trends over time by Department, DRG, Floor, Primary Diagnoses, Location, Day of Week, etc and find areas in need of attention.īefore reading any further, if you are looking for a simple trendline on a chart then there is an out-of-the-box option that only takes a few clicks (click here). These dynamic calculations can be used to simply visualize trends, or to bubble up specific sub-categories of data that are sharply trending up or down over time. In Healthcare (this is a Healthcare Blog) some examples might include Average Length of Stay, Complications, Falls, Performance Metric Rates, Supply Chain Metrics, and more.

The approach used in this example could be applied to any data on a date axis, for any industry. (Video) Discuss how to extend the Linear Regression Trendline calculations to uncover trends within the data and visualize patterns at scale.Provide a link to a sample PBIX file with a copy of the solution.Visualize and interpret the DAX calculations.Add a Linear Regression Trendline to a Dataset and Report using custom DAX.In this article (and related video tutorial) I'll cover the following: Linear trendlines can be useful for trendspotting, forecasting, and pattern identification in data. After designing and creating the example, I thought it would be useful to share with the Community.

Recently I was asked to provide an example of a custom Linear Regression Trendline in Power BI that can dynamically re-calculate for both different levels of a Date hierarchy along with different filter selections. Custom Linear Regression DAX expressions give you insights into all components of the Y = MX + B equation.

Excel trendline custom equation