Тёмный

PUSH the limits of Power BI native VISUALS and CAPTIVATE your audience | TIMELINE chart Step-by-Step 

How to Power BI
Подписаться 223 тыс.
Просмотров 75 тыс.
50% 1

In this video I present the way to make a timeline chart using only native visuals in Power BI. Learn the few tricks that make this visual possible and keep them for the future out-of-the -box ideas!
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
01:00 Data Model and Dataset
01:40 Creating Markers Building the Timeline with a Line chart (Step 1)
05:59 Creating Drop Down Lines with Error bars (Step 2)
07:53 Combine it with the Area Chart (Step 3)
10:28 Area Chart Trick you Need to Know
11:49 Add additional information
15:53 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 RU-vid: 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

Наука

Опубликовано:

 

28 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 188   
@angelosvasileiou5596
@angelosvasileiou5596 Год назад
You're the real king! Just got promoted to BI leader in my company, solely by taking adv your videos & tips for my reports in the past 10 months. I am forever grateful Bas
@HowtoPowerBI
@HowtoPowerBI Год назад
congratulations! 🎉🎊🍾 this comment really made my day! Maybe it started with the video but at the end it is all about what YOU did with it:) super, keep pushing 😎
@brianlee1517
@brianlee1517 Год назад
Congrats Angelos! 🎉 wishing you great success in your new promotion!
@gnam9924
@gnam9924 11 месяцев назад
Congrats
@elishmuel1976
@elishmuel1976 8 месяцев назад
I can't incorporate your tips fast enough. You make me look like a superstar!! Can't thank you enough, Bas. 👍
@pawewrona9749
@pawewrona9749 Год назад
Amazing, you really squeezed maximum out of this visual. Very well done!
@yangkijin
@yangkijin Год назад
Bas, This is freaking awesome! I can't even begin to explain how grateful I am for this incredible chance to learn for free. Thank you so much!😊😊😊
@HowtoPowerBI
@HowtoPowerBI Год назад
Great to hear, happy I can help :):)
@eaglessportvids
@eaglessportvids Год назад
Thank you Bas! I totally needed this tutorial. I’ve been struggling to figure how to do this and you showed me the way!
@HowtoPowerBI
@HowtoPowerBI Год назад
Ah 😎 cool, nice to see you needed thsi visual!
@lijunchen
@lijunchen 11 месяцев назад
Another terrific video! I have not known the errors bars are so useful until today.
@andreicostin3
@andreicostin3 Год назад
Amazing as always, gotta try it on my reports as well :D . Thanks for keeping us updated with all new features 🎉🎉
@HowtoPowerBI
@HowtoPowerBI Год назад
Please do tey ale let me know :)
@HiYurd
@HiYurd Год назад
Excellent job. Really like that PBI visual.
@viettungbui2888
@viettungbui2888 Год назад
Your content is absolutely brilliant, can you also share the data set that you use for these examples? I am new to power BI and i would love to try it practically
@bananageorge2133
@bananageorge2133 10 дней назад
I watched this a while ago and thought it was cool - coming back to it, this is cool, useful, explained well.. thanks so much.
@user-tr2gz3ok5e
@user-tr2gz3ok5e 9 месяцев назад
You are awesome!!I was recently promoted to a Senior Performance Analyst position and timelines will be a major feature that will be used! I start in 3 weeks, but I want to have this knowledge prior to my start date. You are one of my Power Bi geru's.
@HowtoPowerBI
@HowtoPowerBI 4 месяца назад
amazing! congratz hope you like the new position
@jahmed525
@jahmed525 Год назад
Bas your channel and content is hands down the best anywhere. In depth yet so simple to understand the way you explain. Simply no competition out there 😊 My team that I am a part of is migrating from Tableau to Power BI (currently on Feb 2023 version due to IT restrictions). I have local admin permissions on my work laptop so I can upgrade PBI to May/June 2023 but have to wait since need to train my team on PBI features before jumping the gun. Your videos make it sooooo tempting to just update to latest version and start enhancing my dashboards. 😅😅
@HowtoPowerBI
@HowtoPowerBI Год назад
Right? FOMO is real… thanks for the kinds words and keep rocking! 😎👍
@jahmed525
@jahmed525 Год назад
@@HowtoPowerBI FOMO indeed!! :D
@michaaaxiao113
@michaaaxiao113 Год назад
Thank you for the great video! I wish one day I could be as good as you in PBI 🚀! BTW LOVE the error bars, can't wait to try it on in my dashboard
@JorgeSanchez-um7io
@JorgeSanchez-um7io Год назад
Thanks for sharing! You make me love Power Bi!! You are the great master: Crear explanation and easy to replicate
@HowtoPowerBI
@HowtoPowerBI Год назад
Wow, thank you Jorge, this is really great to hear :)
@joaorataoo
@joaorataoo Год назад
Amazing Bas!!! Your capability to blend imagination with tech skills is fantastic! Congratulations!!!💯💯💯💯💯
@HowtoPowerBI
@HowtoPowerBI Год назад
Thank you Joao :) Cheers!
@CrazyT0wn
@CrazyT0wn Год назад
Great instructions as allways! your the man!
@HowtoPowerBI
@HowtoPowerBI Год назад
I appreciate that! 🙏 thanks
@iamkalp6
@iamkalp6 10 месяцев назад
You are brilliant and one of the most innovative person in power BI space, I have come across..keep it up..love your content..
@HowtoPowerBI
@HowtoPowerBI 10 месяцев назад
thanks for those nice words! 😊
@PedroNalin
@PedroNalin Год назад
Awesome! Thanks for sharing!!
@NukeIncharge
@NukeIncharge Год назад
well, that trimmed bared looks great! and as usual great video.
@HowtoPowerBI
@HowtoPowerBI Год назад
Oh thanks 🧔🏻‍♂️😎🤪
@edwinarchico439
@edwinarchico439 Год назад
Outstanding 🎉, in addition to storytelling
@HowtoPowerBI
@HowtoPowerBI Год назад
Thank you! 🙂 happy to hear you like it
@diegolozano2397
@diegolozano2397 Год назад
Thanks a lot, great viedo, hugs from Colombia
@yannkitson116
@yannkitson116 Год назад
Great stuff! Thanks for sharing :)
@HowtoPowerBI
@HowtoPowerBI Год назад
Glad you enjoyed it!
@cedriccot7519
@cedriccot7519 Год назад
You are the man , thank you for posting
@HowtoPowerBI
@HowtoPowerBI Год назад
😎 sure , thx for watching
@bryanbradford9421
@bryanbradford9421 Год назад
Nice! Can't wait to try that out!
@HowtoPowerBI
@HowtoPowerBI Год назад
You should! Many many options!
@julianhandl3652
@julianhandl3652 Год назад
Many thanks, great video! Do you see any possibility to add a hyperlink to those key events? Would be extremely helpful if the end-user could click on it and see the announcement page or whatever.
@LeighRadmore
@LeighRadmore Год назад
Another clever banger! Nice work
@HowtoPowerBI
@HowtoPowerBI Год назад
Appreciate it! :)
@andrekroker420
@andrekroker420 Год назад
It´s hard to describe in words how incredible your work actually is! Thank you a lot!
@HowtoPowerBI
@HowtoPowerBI Год назад
Wow, thank you Andre! :) 😎
@andrekroker420
@andrekroker420 Год назад
@@HowtoPowerBI Dear Bas, how to handle multiple events for the same date?
@maksymkoliada1526
@maksymkoliada1526 Год назад
Simply the best !
@HowtoPowerBI
@HowtoPowerBI Год назад
:) thank you for watching!
@baskis69
@baskis69 Год назад
You are a visual wizard... thank you very much for sharing¡¡¡! 👏👏👏👏👏
@HowtoPowerBI
@HowtoPowerBI Год назад
Thank you! Cheers!
@tauqeer_ahmed
@tauqeer_ahmed Год назад
Many thanks for your videos on Power BI, these are always very helpful and informative. I have a very simple and small question. Can we reuse or call a variable in another DAX expression? For example, I am working on a financial projection assignment. Using a DAX I have calculated the collection percentage and stored it in a variable. Now I want to use this variable in some other DAX expression but I do not see it. In its original DAX where that variable was defined, it appears as (x) but not in other DAX. Please explain if it is possible. Thanks
@allentseng2869
@allentseng2869 Год назад
Amazing stuff, I will definitely be trying this out. Bas, is it possible to do this with multiple lines? Say instead of year being on the x-axis, the year becomes the legend and the x-axis is instead the month, making each year a line so that it is easy to compare the same months. Can we still add annotations to the data points like this?
@zammam5509
@zammam5509 11 месяцев назад
Hey Bas thank you for this channel always greatful still many things to learn from you please guide freshers like me in this field plz@How to Powerbi
@TavandtheTadpole
@TavandtheTadpole 11 месяцев назад
Legend. Thank you.
@limchounghuy5
@limchounghuy5 9 месяцев назад
Thanks for this great video
@MagdyTawfikA
@MagdyTawfikA 3 месяца назад
Much appreciated!
@mutumakimathi
@mutumakimathi 6 месяцев назад
So great!
@parveenbhardwaj4533
@parveenbhardwaj4533 Год назад
It is amazing..Well done, Thank you very much for sharing 👏👏
@HowtoPowerBI
@HowtoPowerBI Год назад
Thank you! Cheers! 😎
@kukeleku13
@kukeleku13 Год назад
Holy moly this is awesome!
@HowtoPowerBI
@HowtoPowerBI Год назад
Glad you like it!
@lumitic774
@lumitic774 Год назад
this is the sort of thing that should be a feature in power bi. I sometimes do similar stuff to have changing colors according to trends in shadow graphs, and I always wonder why the need for such "dataviz engineering"... nevermind, great video! lots of new ideas
@HowtoPowerBI
@HowtoPowerBI Год назад
I totally agree! Sometimes the workaround takes way too long (thinking doing and DAX) for the benefit
@emtatu
@emtatu Год назад
This is brilliant!
@HowtoPowerBI
@HowtoPowerBI Год назад
Glad you think so
@satishkumardommeti8282
@satishkumardommeti8282 Год назад
You are just amazing 🥰
@saeedalamry3857
@saeedalamry3857 Год назад
Hi Bas, can you please make a video on how to create a Waterfall chart with multiple totals (like LY Actual Vs current year actual Vs Target), love your videos man you are my hero :}
@EltonSenne
@EltonSenne 11 месяцев назад
Wow! I'm speakless! What amazing and usefull tip. Congrats! I´ll share it, for sure!!
@HowtoPowerBI
@HowtoPowerBI 11 месяцев назад
Awesome! Thank you Elton :)
@EltonSenne
@EltonSenne 10 месяцев назад
Hi Bas, is there any trick to align the titles to the left rather on the top!? @HowtoPowerBI
@jimmypoopap
@jimmypoopap Год назад
Great new design love it
@HowtoPowerBI
@HowtoPowerBI Год назад
Thank you Jimmy! Cheers!
@andysmudge4849
@andysmudge4849 Год назад
Great as usual
@HowtoPowerBI
@HowtoPowerBI Год назад
Thanks Andy glad you think so! 😊
@spen2431
@spen2431 Год назад
Brilliant... just brilliant. 💥💥
@HowtoPowerBI
@HowtoPowerBI Год назад
😊 thx’
@marksant5488
@marksant5488 Год назад
And I thought I knew the possibilities of PBI... Oh well... :D Thank you for your awesome and useful trainings.
@HowtoPowerBI
@HowtoPowerBI Год назад
PBI has a lot to offer haha especially with all the new buttons you can click now :)
@kadirkkkk
@kadirkkkk Год назад
very creative approach, well done
@HowtoPowerBI
@HowtoPowerBI Год назад
Thank you very much!
@miguelbenito7992
@miguelbenito7992 Год назад
Awesome!!!
@rohanbhattacharyya6600
@rohanbhattacharyya6600 Год назад
Cool and very useful stuff..
@bananageorge2133
@bananageorge2133 4 месяца назад
Many thanks ~
@muhammadbaihaki4301
@muhammadbaihaki4301 Год назад
fantastic video bro. price trend really need this 💪
@HowtoPowerBI
@HowtoPowerBI Год назад
No doubt 👍😊
@jim5400
@jim5400 8 месяцев назад
How do I display events on a parallel line (in date order) please?? Your videos are amazing thanks so much!
@totvabe1
@totvabe1 Год назад
Impressive Bas, as usual on your channel.
@HowtoPowerBI
@HowtoPowerBI Год назад
Much appreciated! Happy to see you here 😎
@juanignacioXI
@juanignacioXI Год назад
Excelent, Bas did u turn off the tooltip for Event Pos Y 1 ?? . Because if not, all the measures will show when we move the mouse coursor over the points, right?
@Saif_Ali_Khan_1301
@Saif_Ali_Khan_1301 Год назад
you are awesome.
@MT-oy2uk
@MT-oy2uk Год назад
Beautiful. I would also try to add zoom slider :)
@HowtoPowerBI
@HowtoPowerBI Год назад
That would be cool!
@egbertdejong6377
@egbertdejong6377 Год назад
Super awesome - as always
@HowtoPowerBI
@HowtoPowerBI Год назад
Thank you! Cheers!
@user-dn3ip7yx3r
@user-dn3ip7yx3r Год назад
Nice and useful video!
@HowtoPowerBI
@HowtoPowerBI Год назад
Glad you think so!
@karaboralekoala1012
@karaboralekoala1012 Год назад
Wow impressive really✊✊✊💥💥
@HowtoPowerBI
@HowtoPowerBI Год назад
Thx😊👍
@perfectionist6624
@perfectionist6624 Год назад
You are superb ❤
@HowtoPowerBI
@HowtoPowerBI Год назад
Thank you so much 😀
@nov1195
@nov1195 Год назад
Bas! The moment you say make sure to hit that subscribe button and meanwhile you make that wave with the hand is so funny 😂
@HowtoPowerBI
@HowtoPowerBI Год назад
🤪👍
@dnielcerqueira
@dnielcerqueira Год назад
It is amazing!!!
@HowtoPowerBI
@HowtoPowerBI Год назад
Thx!
@Zorro.Arslan
@Zorro.Arslan Год назад
Great tutorial and ideas. What if we add start date and end date of the events! If any tip plz
@erhaneren2122
@erhaneren2122 10 месяцев назад
Hey man. It is a great video. How did you connect them?
@sanumpzha
@sanumpzha Год назад
See how happy he is while talking about Error bars.😊😊 Nice video Bas👍
@HowtoPowerBI
@HowtoPowerBI Год назад
Absolutely one of the best features in pbi
@sanumpzha
@sanumpzha Год назад
@@HowtoPowerBI Yes, i love it❤️
@HikimaruL2
@HikimaruL2 Год назад
Super nice!
@HowtoPowerBI
@HowtoPowerBI Год назад
Thanks!
@tubeitz
@tubeitz Год назад
Super!!
@HowtoPowerBI
@HowtoPowerBI Год назад
Thank you! Cheers!😎
@alex...g
@alex...g Год назад
LOVE IT
@HowtoPowerBI
@HowtoPowerBI Год назад
Thanks Alex!
@reubenanderson2725
@reubenanderson2725 Год назад
this is COOL!
@HowtoPowerBI
@HowtoPowerBI Год назад
:):) thx!
@gezin_longuevilleosaer4245
@gezin_longuevilleosaer4245 Год назад
Magic Bas, as always
@HowtoPowerBI
@HowtoPowerBI Год назад
🪄thanks :)
@gersinhopinto1978
@gersinhopinto1978 Год назад
amazing
@HowtoPowerBI
@HowtoPowerBI Год назад
Thank you! Cheers!
@petartopic7856
@petartopic7856 Год назад
What if you needed to incorporate this into combo chart, where both of these would be on the same axis? How would you create dynamic event id?
@OM-yn8pt
@OM-yn8pt Год назад
Really nice creativity! How much of your time is just spent tinkering around? Always impressed by your non-standard use of features
@HowtoPowerBI
@HowtoPowerBI Год назад
Thank you very much! Yeah trying out every button :)
@narendrababu2287
@narendrababu2287 Год назад
Always something new🙂😀
@HowtoPowerBI
@HowtoPowerBI Год назад
:):)
@perfectionist6624
@perfectionist6624 Год назад
True
@pabloperez72
@pabloperez72 Месяц назад
Hi and congratulation for you work. How would you do it with more than 1 milestone per date?
@juanpablorvvv
@juanpablorvvv Год назад
You are very clever!
@HowtoPowerBI
@HowtoPowerBI Год назад
Thank you! 😊
@mauryavijai
@mauryavijai 10 месяцев назад
Very cool
@HowtoPowerBI
@HowtoPowerBI 10 месяцев назад
😎👊
@ChannelRush-id4yx
@ChannelRush-id4yx Год назад
Very nice Bas
@HowtoPowerBI
@HowtoPowerBI Год назад
Thanks for watching
@romanmagic9952
@romanmagic9952 11 месяцев назад
That`s fanstastic feature! Thank you! If there were several events in the table on one date, then only one event for that date is displayed on the graph. how to solve it?
@jean-philippemaltais3360
@jean-philippemaltais3360 3 месяца назад
Add the "event" column in the "Legend" field. That does the trick for me.
@jtsangerman
@jtsangerman Год назад
It'd be nice if labels could be set to the LEFT of a marker, instead of just above or below. But a somewhat complex workaround (and isn't that what Bas's channel is all about?!) is to create a measure or calculated column to offset each datum slightly to the left and add another data series with hidden markers and visible labels. But that's probably getting a bit more complicated than needed.
@HowtoPowerBI
@HowtoPowerBI Год назад
Definitely would look better! 😎🔥
@susantadas8213
@susantadas8213 Год назад
Next level visual though we should need to add custom tooltip to minimize the data label.
@HowtoPowerBI
@HowtoPowerBI Год назад
Always an option:)
@ernests4066
@ernests4066 Год назад
looks like Tableau, nice job men!
@HowtoPowerBI
@HowtoPowerBI Год назад
Guess thats a complement;) haha thx!
@reniellopez5479
@reniellopez5479 Год назад
Hello. What’s inside the dimDate? Thanks a lot!
@adilmajeed8439
@adilmajeed8439 Год назад
Any possibility to share the working file? If not, even that's ok but honestly great work and how we can bring this in our analytics work.
@HowtoPowerBI
@HowtoPowerBI Год назад
:) download link is in the description
@mutantlabor
@mutantlabor Год назад
How did you create the dimDate table and what is its purpose?
@alexpea22
@alexpea22 Год назад
How about a vertical view for this, to make more room for each daye event 🙄 Brilliant tutorial as always, really loving your content 👍👍
@HowtoPowerBI
@HowtoPowerBI Год назад
Will try but it’s generally strange to see.timeline vertically
@user-iz3tx3jo3v
@user-iz3tx3jo3v Год назад
Hi. Maybe you can help me with an advice. How to filter matrix visualization so it will change only values and rows with columns will be untouchable. By using interactions when slicer only filter the table I am getting not that picture that I want. DAX UpdatedScore = CALCULATE( SUM(Data[Score]), ALL(Data), Game[Game] = SELECTEDVALUE(Game[Game])) shows wrong data, but bring almost what i wanted
@unnikrishnansanthosh
@unnikrishnansanthosh Год назад
creativity has no limits as far as BAS is considered
@HowtoPowerBI
@HowtoPowerBI Год назад
🙏 thanks
@CavanHaganInvesting
@CavanHaganInvesting Год назад
TESLA TO THE MOON 🚀 Cool graph but I think I would have just used the date as the custom data label and had the description in the tooltip to keep things tidier
@NukeIncharge
@NukeIncharge Год назад
How about event start and event end.?
@valentinmarguet575
@valentinmarguet575 Год назад
Definitely like it. I dont get to have rhe possibility to set a custom data label. How can I get access to this feature?
@HowtoPowerBI
@HowtoPowerBI Год назад
Hi Valentin, it is in the may version (you need to enable it in the preview options under settings)
@valentinmarguet575
@valentinmarguet575 Год назад
Thank you for the fast reply! I'll try it straightaway
@pk231
@pk231 Год назад
Requesting you to create video for Microsoft Fabric plz
@nolanvondracek3463
@nolanvondracek3463 11 месяцев назад
I'm not seeing the ability to turn on error bars...has the feature been discontinued?
@mugeshkannan3776
@mugeshkannan3776 Год назад
Please add full design😊
@dharmendarrana4191
@dharmendarrana4191 11 месяцев назад
How to create same chart in Excel.
@yonpython9480
@yonpython9480 4 месяца назад
BAS this is cool but not working for me. First of all, I can't see the Custom data labels and there seems to be no way to bring them in. I can apply the setting in "title" but thats not following your steps anymore. Secondly, when i add my actual data in $ figures on the secondary y axis, it either shows as one straight line or does not show at all. I'm not sure what is going on, can you help?
@personalsigh
@personalsigh Год назад
Tried this but the custom label refused to allow me to add the description in
@personalsigh
@personalsigh Год назад
After playing around with this I think the issue is because I have previously used Calculation Groups in the PBI file which affects the auto sum function on numbers which in turn impacts on using the eventid in the chart... even using selected value or sum of the eventid doesn't solve the issue as the event description will not be added as a custom value. very annoying
@kennethsmith9610
@kennethsmith9610 Год назад
Am I missing something? Does this depend on the table dates being in chronological order matching the index column?
@yonpython9480
@yonpython9480 4 месяца назад
Got the same issue and disappointing there is no response to either query because this would be super useful, but I dare say doesn't work for most people without further explanation :(
@user-ck2wz4mi5d
@user-ck2wz4mi5d Год назад
where can I find the data set to practice?
@HowtoPowerBI
@HowtoPowerBI Год назад
Download link in the description
Далее
Checkmark SLICER You Have Not Seen Before | Power BI
13:36
Kettim gul opkegani😋
00:37
Просмотров 1,4 млн
The ULTIMATE Slicer Panel in Power BI
36:15
Просмотров 196 тыс.
Top 3 Survey Visuals in Power BI
25:25
Просмотров 25 тыс.
The ART of Subtle ANIMATION in Power BI
24:46
Просмотров 85 тыс.
New Card Visual Tutorial - Power BI (June 2023 Update)
18:23
MASTERING Bar Charts in Power BI | No more Cut Labels
15:34