need a daily Alert

[Pikachu-Power]

hi all,

there are really less options for alerts in power bi service! i have created following dax formula in PBI Desktop:

Alert = IF([price] >= [price_plan] * 0.25, 1, 0)

and put it in a card. In PBI Service i say in a dashboard when Alert > 0 give an Alert. So i just get an Anlert one time (because 1 > 0) and no more because currently it is every day [price] >= [price_plan] * 0.25. I suppose we get only an Alert when the data changes and 1 doesnt change every day?

Are there some techniques to get every day an Alert when it is 1?

thanks for ideas.

[ibarrau]

Hi. I don't get it. Were you able to configure the alert? the power bi alert configuration step 4 is asking you if you want it daily or hourly:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts#set-data-alerts-in-...

That's the only place to configure alert in Power Bi by default. If you have XMLA endpoint you could execute a query to the dataset by API and send de alert, but you would need coding scripting skills to build it.

I hope that helps,

[Pikachu-Power]

Hello. Yes i could configure it. Every 24 Hours because we update data once a day.  But in the configuration it is written that Alters are only sent if your data changes. And IF([price] >= [price_plan] * 0.25, 1, 0) is every day 1 as long as [price] >= [price_plan] * 0.25. Hence no alerts. 

[ibarrau]

Oh. I see now. You may be able to cheat that changing the 1 from the TRUE response of the if with something like:

RAND() + 1

Sum a random value from 0 to 1 + 1. Then you will always get a different value like 1.23 or 1.54

That way the value will change and be higher than 0.

I hope that helps,