Data Alert based on Table Visual column

[powerbidev123]

Hey folks,

I have a numeric column which has difference between days logic. I am using this column in a table visual.

Is there any way we can set alert such that whenever the difference becomes less 30 days (for example) a message/email is triggered to certain users.

I know the limitations of alert which cant be used for table visual but still is there any other way to achieve this.

[powerbidev123]

@lbendlin I am not relying on  a single numerical value . I want to basically send an alert if any of the values becomes less than 30 then send the details of the customerid,email via an email or just display those records in table visual

[lbendlin]

As @Anonymous stated - create a measure.

[Anonymous · Accepted solution]

Hi @powerbidev123 ,

Based on the description, try creating a measure.

Days_Difference_Alert = IF( MAX(Table1[Days_Difference]) < 30, 1, 0 )

Then, place the measure in a card visual and publish the report to the service.

What’s more, set up alerts on the card visual.

Besides, you can also view the following documents to learn more information.

Set alerts on Power BI reports (public preview) - Power BI | Microsoft Learn

Introduction to Data Activator - Microsoft Fabric | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.   

[lbendlin]

what prevents you from using a card visual?