Current Power Pivot / Tabular Model does not support dynamic threshold settings for KPI. However, some customisations on the data model can be applied to enable dynamic KPI threshold in Power View.
Are you a database developer and wondering how to jump to the Analysis side of the world of data? Join my session with Patrick LeBlanc at the Implementing Tabular Models MVA session on Nov 11, 2014
Schedule Data Refresh is a new feature in Power BI to allow users to refresh data sources in Power Pivot at a defined time or on demand.
Myth Busting Driver Fatalities using Power BI
How to connect GeoFlow to SQL Server database and Tabular Model for millions of rows. This article includes sample workbooks.
Upgrading Excel 2010 workbook with PowerPivot to Excel 2013. Sample workbook used is courtesy of Jason Thomas.
A review of DAX Studio, a simple, yet powerful Excel Add-In for PowerPivot and Tabular Model developer