Set Up Automatic KPI Trackers | Dynamic Alerts in Power BI Desktop

Ғылым және технология

Make sure nobody overlooks any important KPI developments by setting up dynamic alerts. With DAX measures and some design tricks you can create automatic KPI trackers that assist the end users what to focus on.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:56 Alert measure logic and structure
02:17 Creating a basic version of the alert measure
08:16 Improving the notification list design and testing
10:07 Adding more KPIs to the alert measure
12:47 Adding more fields to the alert measure
15:35 Integrating the alerts in a notification tooltip
17:13 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO​
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZread: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

Пікірлер: 65

  • @hi55us2
    @hi55us2 Жыл бұрын

    Adding features like this also helps a lot with helping drive user adoption. Everyone will want to see this week's notifications!

  • @utubeAgape
    @utubeAgape Жыл бұрын

    I like this because it adds value for report consumer to quickly get a pulse of what is happening with the business. Thank you!

  • @brettwilson3795
    @brettwilson3795 Жыл бұрын

    Great video, will help with those that just look for the overview and not / can't analyse the information.

  • @azidburn80
    @azidburn80 Жыл бұрын

    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.

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Thanks Roman! Much appreciated! 😎

  • @nishantkumar9570
    @nishantkumar9570 Жыл бұрын

    Thank you so much for such an insightful explanation. Awesome

  • @virajphadnis
    @virajphadnis Жыл бұрын

    Very useful as always, Nice, will use it as an value add in my dashboards. Thanks Bas!

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    That’s awesome let me know how it goes!

  • @roo72
    @roo72 Жыл бұрын

    Serendipity, was just working on something similar. Thanks!

  • @ramonmmbarbosa
    @ramonmmbarbosa Жыл бұрын

    Mindblowing dude, thanks!

  • @PedroCabraldaCamara
    @PedroCabraldaCamara Жыл бұрын

    Amazing Bas!! Thank you so much

  • @paulrockliffe2378
    @paulrockliffe2378 Жыл бұрын

    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?

  • @J44YC33
    @J44YC33 Жыл бұрын

    Amazing videos. Thanks for all your work 👌

  • @quentinmartiny1615
    @quentinmartiny1615 Жыл бұрын

    Really good video thanks!

  • @natibelay6157
    @natibelay6157 Жыл бұрын

    My favorite power bi developer

  • @wilsonho47
    @wilsonho47 Жыл бұрын

    Thank you Bas! Total blew my mind!

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Glad to hear this Wilson!

  • @tomduffhues622
    @tomduffhues622 Жыл бұрын

    Automagically indeed . Very nice Bas.

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    😀thx Tom

  • @ca1ifax
    @ca1ifax Жыл бұрын

    As always, amazing work! Kinda surprised though that you didn't add a parameter like you always do to have a dynamic threshold. :)

  • @brando2818
    @brando2818 Жыл бұрын

    Always great content, keep it up

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Definitely will - thanks Brando 😊

  • @normandass6053
    @normandass6053 Жыл бұрын

    Amazing Mate, the best trick :)

  • @egbertdejong6377
    @egbertdejong6377 Жыл бұрын

    As always fantastic content- thnaks !

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Glad you think so Egbert!

  • @matiasmejail6201
    @matiasmejail6201 Жыл бұрын

    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.

  • @carloscorominola7254
    @carloscorominola7254 Жыл бұрын

    Excellent video. Congratulations. Carlos

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    appreciate it, thanks Carlos!

  • @roscaacinitram3058
    @roscaacinitram3058 Жыл бұрын

    Impresionante, gracias brother..

  • @andersgustavsson213
    @andersgustavsson213 Жыл бұрын

    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.

  • @kellyyang5810
    @kellyyang5810 Жыл бұрын

    Thanks for sharing.

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Thx for watching Kelly :)

  • @tushardesai4966
    @tushardesai4966 Жыл бұрын

    Hello Bas, greatly appreciate your videos. I have a request- can you share knowledge on creating one graph from two slicers? Thank you.

  • @neelterdal
    @neelterdal Жыл бұрын

    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

  • @sanjaybnarayan
    @sanjaybnarayan Жыл бұрын

    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

  • @balaji_906
    @balaji_906 Жыл бұрын

    Fantastic video

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Thx Balaji

  • @rahulmaurya9444
    @rahulmaurya9444 Жыл бұрын

    Owsome idea 👍

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Thanks Rahul!

  • @rohitmeena7764
    @rohitmeena7764 Жыл бұрын

    Love from India 🙂

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Love back from germany 😁

  • @NikoSuomiUlkoilee
    @NikoSuomiUlkoilee Жыл бұрын

    Really nice tips all around

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Thanks Niko!

  • @NikoSuomiUlkoilee

    @NikoSuomiUlkoilee

    Жыл бұрын

    ​@@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.

  • @CHQAQC
    @CHQAQC Жыл бұрын

    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.

  • @tinaflemons4022
    @tinaflemons4022 Жыл бұрын

    Definition of awe·some extremely impressive or daunting; inspiring great admiration, - ENOUGH SAID ***How to Power Bi with Bas*** Thank you

  • @rmthibodeaux
    @rmthibodeaux Жыл бұрын

    Amazing Video Bas! You’re killing it on the reg.

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    thx a lot Mike!

  • @carstenbuchmann2077
    @carstenbuchmann2077 Жыл бұрын

    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!

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Thx! This is premier pro

  • @andreibuja6397
    @andreibuja6397 Жыл бұрын

    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.

  • @mirrrvelll5164
    @mirrrvelll51644 ай бұрын

    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.

  • @AT-LT
    @AT-LT Жыл бұрын

    Very Good, can you add a nofication Date to the Alert Header somehow?

  • @astralyog
    @astralyog Жыл бұрын

    Fan of you!

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Thanks a lot for watching my videos!

  • @adityasrivastava6564
    @adityasrivastava6564 Жыл бұрын

    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

  • @SB-ld6xn
    @SB-ld6xn Жыл бұрын

    Hey Bas.. can you please make a video on Waterfall Visual and challenges faced while working with financial data

  • @chrisa8203

    @chrisa8203

    Жыл бұрын

    Use the free Simple waterfall chart add-on. It works way better than the default chart. You can add measures as bridge items too.

  • @christophesirigu7063
    @christophesirigu706310 ай бұрын

    Hi PowerBI community! Can we set alert of a value of a table? or we only can do it by measure?

  • @sukoi2113
    @sukoi2113 Жыл бұрын

    I took pride as a power bi developer, all because of you and your vision. Thank you for being on earth with me. 🦾

  • @helloworldtt9271
    @helloworldtt9271 Жыл бұрын

    how to add the punctuation though?

  • @pocheng5438
    @pocheng5438 Жыл бұрын

    Can you teach whta is windows key function in 15:28

  • @hmmm8158
    @hmmm8158Ай бұрын

    Too hard!

  • @HerrAby
    @HerrAby Жыл бұрын

    unlucky the pbix isnt available :(

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    you can download the pbix following the download link in the description 🙂

Келесі