the functionality you're describing is available only on Power BI service (trough dashboards) and in Fabric with Real-time workload (reflex artifacts).

In Power BI Report Server you can leverage SQL Server to build you custom application to check values (with triggers or jobs) and to send out notifications via mail.