Jordi-f on 27 Jan 2017 18:30:22
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
- Comments (3)
RE: KPI Alerts based on (changing) target value from data model
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.
RE: KPI Alerts based on (changing) target value from data model
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)
RE: KPI Alerts based on (changing) target value from data model
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.