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.
Hi everyone!
I need to create an alert for each row in my dataset, whenever any of them goes below 5.
Currently i have 85 rows, i could create 85 visuals for each, but how to handle when there is a new row in the dataset?
I know it's a bit weird approach, maybe someone has a better idea?
Many thanks!
Gazi
Solved! Go to Solution.
Create a measure like this and set a notification for > 0
BelowFive = VAR myCount = COUNTROWS(FILTER(Table,[Column]<5) RETURN IF(ISBLANK(myCount),0,myCount)
How could we apply this at a monthly level for eg. sales at monthly level with alerts for a salersperson if the number dips below a certain threshold ?
Name Jan Feb Mar
A 100 125 85
A 110 105 95
A 100 95 100
Hi I am just wondering is that possible to set an alert and get the relevant project name?
Thanks a lot!
Create a measure like this and set a notification for > 0
BelowFive = VAR myCount = COUNTROWS(FILTER(Table,[Column]<5) RETURN IF(ISBLANK(myCount),0,myCount)
Not the solution I would have thought of at all, but I have to say this would do the trick nicely. Thanks!
Thank you @Greg_Deckler!
It actually worked! 🙂
But is there any way to see relevant row's data? i mean which row triggered it (it contains project names)
I believe that you can only set alerts on numeric data so it wouldn't work to concatenate all the project names rows together which was my first thought. Glad it worked though!! If I come up with something I'll let you know.
Hi Greg,
do you have already a workaround regarding the data alert with data name (like the project name in this example)?
Thank you in advance.
Hi Greg @Greg_Deckler , I need some help regarding these data alerts. I've also started a new topic for my issue here.
I've made a measure following your help.
Notification =
VAR myCount = COUNTROWS(FILTER(SickEmployees;([Days sick]>=2)))
RETURN IF(ISBLANK(myCount);"None";myCount)
What I think it should do: it counts all rows where 'days sick' >= 2. I get 'none' beceause it's blank. If I change the measure to >=1 it gives me 74. The sum of days sick.
What I expect / want: I want to get a notification when someone is sick for >= 17 days. So the measure should be changed to
VAR myCount = COUNTROWS(FILTER(SickEmployees;([Days sick]>=2)))
RETURN IF(ISBLANK(myCount);"None";myCount). But like I said, this gives me 'none'.
You can find the sample file here in my Dropbox.
@Greg_Deckler Yeah I am also trying to think about any possible way to show the relevant project names, which triger an alert, that would be an amazing workaround the current limitation of the Data Alert in PowerBI.
Thanks a lot! 🙂
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |