The 'alerts' functionality in the Power BI service let's users set an 'alerts' based on a threshold. When using a KPI the target value is copied as the default threshold but when the target changes, the threshold will not be adjusted. In a scenario where you would use a YTD value to compare to a YTD target and want to receive a notification based on that adjusted target this should be updated automatically. For example: Year-month: 2017-01 Actual_YTD: 500.000 Target_YTD: 550.000 When pinned to a dashboard the 'alerts' is set based on the copied value from the target: 550.000 Data changes Year-month: 2017-01 Actual_YTD: 560.000 Target_YTD: 550.000 'alerts' is fired Data changes Year-month: 2017-02 Actual_YTD: 650.000 Target_YTD: 600.000 'alerts' should be fired based because the actual value has gone over the target again
4 Comments
- MAwbre
Advocate I
This is critical for our business use (manufacturing). A target will change from day to day, and in some cases hour to hour. Having a static threshold value completely removes the potential use of this feature. - I only can support was have been said here and in the first comment! (currently data 'alerts' feature is not from any use for me and my community - w/o haveing this feature)
- Please consider this - making the threshold value dynamic reading from the data model. For example if we want to evaluate is the maximum # of orders was reached, we have a measure/calculated column with that and use it in the threshold value.
- Status added:Needs Votes
