Forum Discussion
Alert or email triggered by table value
- 3 years ago
I am affraid this is not possible.
There might be an workaround, but it's bit advanced:
1. You might create Power Automate flow, which queries the data and basically "replicate" the table you have above.
2. You set up a condition in your flow. Something like IF Albania >5, THEN xxx
3. You set up action, which would be notification.
I think the basic idea can be understood from the following video:
https://www.youtube.com/watch?v=WUSo5GLV6uk&t=1s&ab_channel=Curbal
Hi anderb ,
you can't use tables for your notifications but you can use dashboard and tiles. There is possibility to set up power automate flow, which can send any kinds of notifications.
Details are here:
https://learn.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts
Thanks for you response Migasuke . I'm surprised some sort of alert or notification can't be generated from a table value.
Alternativly - is it possible to highlight a linked slicer based on a change in cell value?
Thank you
- Migasuke3 years agoMemorable Member
Hi,
how should it work? I am not sure if I get it.- anderb3 years agoNew Member
Hopefully the screenshot below explains it a little better. So as an example:
If the value in the AvgDespatch column is greater than 5, highlight the associated country in the slicer.
- Migasuke3 years agoMemorable Member
I am affraid this is not possible.
There might be an workaround, but it's bit advanced:
1. You might create Power Automate flow, which queries the data and basically "replicate" the table you have above.
2. You set up a condition in your flow. Something like IF Albania >5, THEN xxx
3. You set up action, which would be notification.
I think the basic idea can be understood from the following video:
https://www.youtube.com/watch?v=WUSo5GLV6uk&t=1s&ab_channel=Curbal