The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi guys,
I've got a line chart which displays two lines representing two temporal series: I'd like to highlight somehow when the difference between the values of the two lines exceed a threshold, any clue - example about it?
Thanks in advance!
I don't think the line chart visual offers this kind of behavior. The closest thing it has is the reference line, but I guess it's not what you're looking for. The best option I can think of at the moment is to create two calculated columns for each column displayed on the line chart, defined as follows:
1. ColNameBelowThreshold = IF([ColName] <= threshold, [ColName], BLANK());
2. ColNameOverThreshold = IF([ColName] > threshold, [ColName], BLANK());
3. threshold can be a variable, a static value, or a calculation of some sort that represents the desired threshold.
4. You might need to tweak the above formulas a bit, depending on your data, so that one line would pick up where the other one ends.
You could then display them both on the line chart, and give ColNameOverThreshold a different color in the "Data Colors" menu in the formatting pane to make it apprear highlighted.
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:
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.
Many thanks Itayrom
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
46 | |
3 | |
3 | |
2 | |
2 |