Forum Discussion
Line Chart: how to warn when values differences between two lines when exceeding a threshold
Hello Luca,
I' am also stuck with the same scenario where I need to ive a warning message/pop up if for eg sales target are not achieved etc..
If you found solution to the above then please guide me as well
Thanks in advance
Gaurav
gkhare, regarding your case, what I would do is as follows:
1. Add a measure with a DAX formula with the following structure- TagetsNotAchieved = IF(calculation, warning_msg, else_msg), where:
- calculation is a calculation to check if the target was achieved(E.g. SUM([Sales]) >= target).
- warning_msg is a static textual to be shown when the target was not achieved(E.g. "Sales target is not achieved").
- else_msg is a static textual value to be shown when the target was achieved,or an empty string(I.e. "") if you don't want a message to be shown.
2. Add a card visual to your report, and set the TagetsNotAchieved measure as its field.
3. Change the Card's formatting to make it look more "warningy".
Hi,
Many Thanks for providing solution...
One more help required..kindly guide me on how to send alert in form of an email if the difference of value/target exceeds a threshold limit.
Regards
GK
gkhare, I hardly think Microsoft would provide a way for sending emails from custom visuals, since it poses a great security risk. E.g. you could write a custom visual that would send you confidential data from corporations using it. Therefore, I'm pretty sure that custom visuals running in a sandboxed environment would not be able to do so.
In theory, though, if that functionality wasn't blocked, I would use ajax to notify a remote server with email-sending capabilities that the threshold was exceeded.
