This is great, really enjoyed this as it was on my list of things to work out. A couple of thoughts; you could output the alerts via two Measures, one the text, the other the value. That would let you align all your values by using two columns in the visual, it's a little neater and you can then sort by the largest change or do other stuff using the change values. Then you have the option of using PowerAutomate to put your alerts into a Teams message or Adaptive Card and get the alerts out without your users opening the reports first. Embed Power App to let users sign up to the notifications perhaps? I would love to know if it's possible to let the users set their own alert levels for the stuff they care about? I guess you need a PowerApp to collect some info then build a table for all users, then I get stuck. Row Level Security on that table maybe?
Great video! Do you have in plan to make some video on alerts (data drive) in Power BI Service? Is there any possible options to tweak those 0/1 possibilities when you add alerts ranges? For instance, I got a table with Location vs Daily Sales, and I would like to know how many locations got daily sales, which locations sales was less than maybe last week/month (same period) or if there is no sales at the given day? Now what I need to do is to open daily sales report and check there for any differences and to locate what/where, instead of receiving notification on my Email,phone of some issue.
Hey Bas! I just love your videos on power bi and it has helped me great way in my career. Can you make video on: Like using slicer...by choosing an option in slicer....it should navigate to new page or window...and the same should work for multiple choices....opening multiple windows on same sheet...I know I'm asking too much....hope you would help me out on this. Thanks and Regards
Ones again excellent video and content? Follow up question: Is it possible to push notification alerts to users via email in a power bi report or is it only available in dashboard? e.g. a power automate flow which automatically is triggered when a predefined alert limit has been achieved.
OMG Bas! This is awesome 👍 Thanks for the tip! I have an unrelated question: Can we do a page navigation with hierarchy? For example sales pages have a different hierarchy, ops has a different one and so on! Help would be appreciated
Hello Bas, I really appreciate your work. Visually clean and appealing. So I'd like to ask you which software are you using to create your videos? Thanks a lot!
Great video as usual 🙂 Question about something else, do you have a video where you show how to highlight a button that is pressed? I thought it was in one of your earlier video but remember which one.
Hi, even though I have followed the exact same formulas, I get nothing in the notifications because apparently the value for my WoW% measure is always 0, which is not because if I put the measure in a matrix and I check its value on a weekly trend, it's all the time higher/lower than 0, the same if I add the parameters for which I want to display it (ex: Class/Manufacturer in your case). So any ideas why the "Alerts" formula sees my Wow% value as 0 all the time for every parameter when in reality it is not ? Thank you for your great work.
Maybe this information can be useful for someone: (it was for me) that you should not create a comparison in the last step, just a true condition is valid there. When not, this will not work. But we can add conditions in the relevant variable.
I have connected my outlook to power BI and added a automated flow that will refresh the dataset every 5 mins. I want that when a new mail arrives from a specific sender with a specific subject then a pop up window will open with a sound and shows the message body of that email or whatever I want in my power BI server
@@HowtoPowerBI No problem at all! Really being inspired by your videos in recent weeks. I had some creative ideas also back in the days, but the reporting has gotten so stale in few projects that I had lost the inspiration to investigate and find new things within the Power BI. But these little tips and tricks you are presenting, are a great reminder, that you can do something out of the box with PBI as well! You are not only limited with the basic graphs you are provided. It is only up to you, to utilize the tool Power BI with your own imagination. So a BIG thank you, for reminding me, that PBI is capable to do amazing things as well. And with a little bit imagination, one can create informational and neat looking reports! And in addition, these kind of functionalities like alerts, might seem a little thing, but it is actually a massive improvement for report UI and for the users. SO once again, thanks thanks thanks thanks thanks.
Adding features like this also helps a lot with helping drive user adoption. Everyone will want to see this week's notifications!
I like this because it adds value for report consumer to quickly get a pulse of what is happening with the business. Thank you!
Great video, will help with those that just look for the overview and not / can't analyse the information.
Following you since a couple of days and want to tell you that your content is awesome. Keep up the great work and may thanks.
Thanks Roman! Much appreciated! 😎
This is great, really enjoyed this as it was on my list of things to work out. A couple of thoughts; you could output the alerts via two Measures, one the text, the other the value. That would let you align all your values by using two columns in the visual, it's a little neater and you can then sort by the largest change or do other stuff using the change values.
Then you have the option of using PowerAutomate to put your alerts into a Teams message or Adaptive Card and get the alerts out without your users opening the reports first. Embed Power App to let users sign up to the notifications perhaps?
I would love to know if it's possible to let the users set their own alert levels for the stuff they care about? I guess you need a PowerApp to collect some info then build a table for all users, then I get stuck. Row Level Security on that table maybe?
My favorite power bi developer
Very useful as always, Nice, will use it as an value add in my dashboards. Thanks Bas!
That’s awesome let me know how it goes!
Serendipity, was just working on something similar. Thanks!
Amazing Video Bas! You’re killing it on the reg.
thx a lot Mike!
Great video! Do you have in plan to make some video on alerts (data drive) in Power BI Service? Is there any possible options to tweak those 0/1 possibilities when you add alerts ranges? For instance, I got a table with Location vs Daily Sales, and I would like to know how many locations got daily sales, which locations sales was less than maybe last week/month (same period) or if there is no sales at the given day?
Now what I need to do is to open daily sales report and check there for any differences and to locate what/where, instead of receiving notification on my Email,phone of some issue.
Automagically indeed . Very nice Bas.
😀thx Tom
Always great content, keep it up
Definitely will - thanks Brando 😊
Very Good, can you add a nofication Date to the Alert Header somehow?
Just amazing!😃
Amazing videos. Thanks for all your work 👌
Thank you Bas! Total blew my mind!
Glad to hear this Wilson!
Excellent video. Congratulations. Carlos
appreciate it, thanks Carlos!
Hey Bas!
I just love your videos on power bi and it has helped me great way in my career.
Can you make video on:
Like using slicer...by choosing an option in slicer....it should navigate to new page or window...and the same should work for multiple choices....opening multiple windows on same sheet...I know I'm asking too much....hope you would help me out on this.
Thanks and Regards
Ones again excellent video and content? Follow up question: Is it possible to push notification alerts to users via email in a power bi report or is it only available in dashboard? e.g. a power automate flow which automatically is triggered when a predefined alert limit has been achieved.
Can you teach whta is windows key function in 15:28
Thank you so much for such an insightful explanation. Awesome
Amazing Mate, the best trick :)
Mindblowing dude, thanks!
OMG Bas! This is awesome 👍 Thanks for the tip!
I have an unrelated question:
Can we do a page navigation with hierarchy? For example sales pages have a different hierarchy, ops has a different one and so on! Help would be appreciated
Love from India 🙂
Love back from germany 😁
Hello Bas, I really appreciate your work. Visually clean and appealing. So I'd like to ask you which software are you using to create your videos? Thanks a lot!
Thx! This is premier pro
Hello Bas, greatly appreciate your videos. I have a request- can you share knowledge on creating one graph from two slicers? Thank you.
Great video as usual 🙂 Question about something else, do you have a video where you show how to highlight a button that is pressed? I thought it was in one of your earlier video but remember which one.
As always, amazing work! Kinda surprised though that you didn't add a parameter like you always do to have a dynamic threshold. :)
As always fantastic content- thnaks !
Glad you think so Egbert!
Hi, even though I have followed the exact same formulas, I get nothing in the notifications because apparently the value for my WoW% measure is always 0, which is not because if I put the measure in a matrix and I check its value on a weekly trend, it's all the time higher/lower than 0, the same if I add the parameters for which I want to display it (ex: Class/Manufacturer in your case). So any ideas why the "Alerts" formula sees my Wow% value as 0 all the time for every parameter when in reality it is not ?
Thank you for your great work.
Love it ❤!
Really good video thanks!
Amazing Bas!! Thank you so much
Hi PowerBI community! Can we set alert of a value of a table? or we only can do it by measure?
Maybe this information can be useful for someone: (it was for me)
that you should not create a comparison in the last step, just a true condition is valid there. When not, this will not work. But we can add conditions in the relevant variable.
Impresionante, gracias brother..
I have connected my outlook to power BI and added a automated flow that will refresh the dataset every 5 mins. I want that when a new mail arrives from a specific sender with a specific subject then a pop up window will open with a sound and shows the message body of that email or whatever I want in my power BI server
Really nice tips all around
Thanks Niko!
@@HowtoPowerBI No problem at all! Really being inspired by your videos in recent weeks. I had some creative ideas also back in the days, but the reporting has gotten so stale in few projects that I had lost the inspiration to investigate and find new things within the Power BI.
But these little tips and tricks you are presenting, are a great reminder, that you can do something out of the box with PBI as well! You are not only limited with the basic graphs you are provided. It is only up to you, to utilize the tool Power BI with your own imagination.
So a BIG thank you, for reminding me, that PBI is capable to do amazing things as well. And with a little bit imagination, one can create informational and neat looking reports! And in addition, these kind of functionalities like alerts, might seem a little thing, but it is actually a massive improvement for report UI and for the users.
SO once again, thanks thanks thanks thanks thanks.
Definition of awe·some
extremely impressive or daunting; inspiring great admiration, - ENOUGH SAID ***How to Power Bi with Bas***
Thank you
how to add the punctuation though?
I took pride as a power bi developer, all because of you and your vision. Thank you for being on earth with me. 🦾
Owsome idea 👍
Thanks Rahul!
Hey Bas.. can you please make a video on Waterfall Visual and challenges faced while working with financial data
Use the free Simple waterfall chart add-on. It works way better than the default chart. You can add measures as bridge items too.
Thanks for sharing.
Thx for watching Kelly :)
Fan of you!
Thanks a lot for watching my videos!
unlucky the pbix isnt available :(
you can download the pbix following the download link in the description 🙂
Too hard!
Fantastic video
Thx Balaji