Improve your VISUALS I How to turn a MEASURE into a KPI in Power BI

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

In this video I show you how to turn measures into KPIs using Tabular Editor. Enjoy the video and subscribe for more videos like this!
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 ⏱️
---------------------------------
0:00 Intro
1:03 Turning a measure into a KPI
3:00 Writing the status expression
4:45 Adding a status graphic
5:30 Adding an upper and lower bound for the middle status
7:48 Showing no icon when there is a blank
8:45 Clean up the table / matrix visual
9:36 Adding the trend expression to the KPI
11:37 What about conditional formatting
13:11 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

Пікірлер: 57

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

    Thank you so much for all your videos!

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

    This is soooo good Bas - thank you

  • @xyclos
    @xyclos2 жыл бұрын

    Thank you very much. Clear and peaceful !!!

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    :):) thanks a lot 👍

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

    All your videos are so great

  • @Pjotterbolte
    @Pjotterbolte2 жыл бұрын

    Thanks Bas! Looks awesome, I was still typing out my measures but this seems a lot easier.

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    happy to hear it's helpful! 😀

  • @manish.nsYoutube
    @manish.nsYoutube2 жыл бұрын

    Great video Bas.. Was able to associate the goal with the what if parameter.. Perfect once you also tie it to your dynamic range video.

  • @dcpowered
    @dcpowered2 жыл бұрын

    This video made me subscribe! Excellent explanation about KPI and crystal clear. Could you please make a video to show how to do the same without installing extra software since it is not allowed on my work laptop.

  • @evedickson2496
    @evedickson24962 жыл бұрын

    Definitely going to give that a try

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    I hope it worked out! 😀

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

    Excellent video. Maybe it would be interesting too to do it without tabular. Thanks for sharing.

  • @tubeitz
    @tubeitz2 жыл бұрын

    Excellent Video, thank you

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    You are welcome! Happy to hear you find it useful

  • @ThanhNhandl
    @ThanhNhandl2 жыл бұрын

    Very useful and nice trick, I ♥ it so much!

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    Thx Thành!! 😀

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

    Very helpful video. Could you please make a video to show how to show burndown chart based on target and actual by month? Thank you so much.

  • @juancarlosnavarretelopez7938
    @juancarlosnavarretelopez79382 жыл бұрын

    THANKS, Excellent

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    Thanks for watching Juan! 😀

  • @cpassuel9857
    @cpassuel98572 жыл бұрын

    Very interesting video. I just wondering why you test blank values after the comparison. It seems less optimized to me (even if the impact is minimal)

  • @spen2431
    @spen24312 жыл бұрын

    👍👍👍👍👍 Nice. Thanks for sharing.

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    Thanks for watching again!! 😀

  • @user-ei5mp2ks3l
    @user-ei5mp2ks3l Жыл бұрын

    Great video, I've a question please, how to use the KPI Status to count the (-1) and present them as a card?

  • @CinnamonBuns19
    @CinnamonBuns192 жыл бұрын

    Thanks!

  • @CinnamonBuns19

    @CinnamonBuns19

    2 жыл бұрын

    Loving the content, keep it up!

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    thank you so much for your support of the channel, it means a lot to us to hear it is helpful and enjoyable. More is coming, stay tuned :)

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

    Great stuff. How can you apply this to a matrix. I have tried and i think there is some tweaking required as the status indicators will not show all way through

  • @bravucod
    @bravucod2 жыл бұрын

    thanks

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    thx for watching!!! 😀

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

    Thank you verymuch for this video, I would like to understand how we can include time in KPI for Eg for call center dashboard Average Handling Time (AHT) is one of the KPI which i am unbale to show it in KPI indicator as time format, is any alternative for this

  • @juanignacioXI
    @juanignacioXI2 жыл бұрын

    Can it be done without tabular editor?

  • @RedGoddesscom
    @RedGoddesscom2 жыл бұрын

    Many thanks!!! Do you have a place where ppl submit an idea for the next video ? I'll drop it here. Created a clickable card, which takes to Bookmark ( hidden page) that has a number of filters hence need to have data ticked under bookmark ( if unticked, losing all necessary filters) .However, when filter applied on the main page, filter doesn't take to the bookmark page. I know that filter would pass to the bookmark page when data is unticked... but I need it ticked! Any tricks? Thanks

  • @sravankumar1767
    @sravankumar17672 жыл бұрын

    Nice 👌

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    thank you Sravan!!! 😀

  • @sentidocomun3096
    @sentidocomun30962 жыл бұрын

    Cool useful 😃

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    Thanks a lot!

  • @AndresGuillermo
    @AndresGuillermo2 жыл бұрын

    How can we create a measure to change the color of a column that represents the maximum value automatically?

  • @luisaymarinacruz
    @luisaymarinacruz7 ай бұрын

    One more helpful video. Thanks Bas :). Would you continue doing it with Tabular editor after the October 2023 calculation feature?

  • @HowtoPowerBI

    @HowtoPowerBI

    7 ай бұрын

    i don't think you can add kpis yet in power bi itself (only calculation groups was added)

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

    How you get sales forecast?

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

    Can you share the dataset I mean the excel/csv data?

  • @bhupoinedmonton
    @bhupoinedmonton2 жыл бұрын

    I am not able to create KPI in Tabuler 3, i have installed Trial version

  • @teddyfabriciocordovasaenz3018
    @teddyfabriciocordovasaenz30189 ай бұрын

    Is tabular editor the same as DAX studio?

  • @lucylu5752
    @lucylu57522 жыл бұрын

    in this case, could you please tell me --- how to get sales forecast?

  • @saifashraf9714

    @saifashraf9714

    Ай бұрын

    did u know how?

  • @kaushikdwivedi1845
    @kaushikdwivedi18454 ай бұрын

    How to take total forecast measure

  • @HowtoPowerBI

    @HowtoPowerBI

    4 ай бұрын

    see link to download file in the description

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

    Any tutorial without external tools? My company disables them

  • @HowtoPowerBI

    @HowtoPowerBI

    Ай бұрын

    no, for now only possible with external tools

  • @teddyfabriciocordovasaenz3018
    @teddyfabriciocordovasaenz30189 ай бұрын

    Is this video updated?

  • @SamehRSameh
    @SamehRSameh2 жыл бұрын

    Please explain M language from scratch

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

    for the reason as to why to use KPI go to 12:47 xD

  • @alicedwonderland7733
    @alicedwonderland77332 жыл бұрын

    But Tabular Editor isn't free... Not after the first 30 days :(

  • @vladsamoilov9905

    @vladsamoilov9905

    2 жыл бұрын

    you can have free version as well

  • @janf5021
    @janf50212 жыл бұрын

    The presenter is attractive the tool is not by pity - neither powerBi nor that „brake your fingers“ Threshold editor…. The only thing i like about power BI is that it offers anti-join oob.

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    Hi Jan 🙂 look into alternatives like Tableau - maybe it's more your cup of tea

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

    Prachtige filmpjes Bas, mooi en duidelijk add me ff op linkedin

Келесі