Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i currently have a table that counts down the number of days from 180 to 0 to remind me when an invoice is due
does anyone know if there is a way to create an email alert to tell me when an invoice hits 0 on the countdown?
Is it possible to create a filter table where it only adds a new row of data when an invoice hits zero and tie this to a card counts the number of rows. when the row increases by 1 then this can trigger an automated email alert?
any help would be greatly appreciated
Solved! Go to Solution.
@Anonymous If you pin your card with # invoices at 0 to a dashboard you can set up an alert following this doc Set data alerts in the Power BI service - Power BI | Microsoft Docs.
For your ask on the daily change alert, you can create a measure that populates a card that will only be the daily change and pin that to a dashboard and have the alert set up. For example:
Today Change Since Yesterday 0 Invoices =
VAR yesterdayinv =
CALCULATE (
COUNTROWS ( 'Invoices' ),
FILTER ( 'Invoices', [Days Until Due] <= 0 ),
'Date'[Date]
= TODAY () - 1
)
VAR todayinv =
CALCULATE (
COUNTROWS ( 'Invoices' ),
FILTER ( 'Invoices', [Days Until Due] <= 0 ),
'Date'[Date] = TODAY ()
)
VAR diff = todayinv - yesterdayinv
RETURN
diff
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
@DataZoe i have modified the measure you created as below
@Anonymous If you pin your card with # invoices at 0 to a dashboard you can set up an alert following this doc Set data alerts in the Power BI service - Power BI | Microsoft Docs.
For your ask on the daily change alert, you can create a measure that populates a card that will only be the daily change and pin that to a dashboard and have the alert set up. For example:
Today Change Since Yesterday 0 Invoices =
VAR yesterdayinv =
CALCULATE (
COUNTROWS ( 'Invoices' ),
FILTER ( 'Invoices', [Days Until Due] <= 0 ),
'Date'[Date]
= TODAY () - 1
)
VAR todayinv =
CALCULATE (
COUNTROWS ( 'Invoices' ),
FILTER ( 'Invoices', [Days Until Due] <= 0 ),
'Date'[Date] = TODAY ()
)
VAR diff = todayinv - yesterdayinv
RETURN
diff
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
i have created a date table to filter data from my main table using
@Anonymous Once you pin the card to a dashboard, you can click the "..." on the tile and set up the alert. No flow needed :).
You can also set them up with a flow too, if you don't want to create a dashboard.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
@DataZoe i have modified the measure you created as below
@Anonymous that is awesome to hear!
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
i have tested the above and the card still reads as zero even though 2 invoices are now due according to the measure. these are present in my filtered table
i have looked at the table and although i have only 2 invoices showing as due in the data section i can see each invoice has multiple rows, would this require a distinct count filter? i notice the readout at the bottom reads 36 rows disctinct count 2
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |