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

[@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]

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]

Congrats Angelos! 🎉 wishing you great success in your new promotion!

[@gnam9924]

Congrats

[@pk231]

Requesting you to create video for Microsoft Fabric plz

[@satishkumardommeti8282]

You are just amazing 🥰

[@HikimaruL2]

Super nice!

[@HowtoPowerBI]

Thanks!

[@nickeldred1]

Hey Bas, I'm recreating this at work and can't work out why only the events from 7 upwards are showing... any ideas? 🤞

[@nolanvondracek3463]

I'm not seeing the ability to turn on error bars...has the feature been discontinued?

[@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?

[@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]

Great to hear, happy I can help :):)

[@ernests4066]

looks like Tableau, nice job men!

[@HowtoPowerBI]

Guess thats a complement;) haha thx!

[@nguyenngothuong]

tutorial CARD (NEW) please

[@HowtoPowerBI]

Yes yes in making ;)

[@NukeIncharge]

How about event start and event end.?

[@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]

Hi Valentin, it is in the may version (you need to enable it in the preview options under settings)

[@valentinmarguet575]

Thank you for the fast reply! I'll try it straightaway

[@muhammadbaihaki4301]

fantastic video bro. price trend really need this 💪

[@HowtoPowerBI]

No doubt 👍😊

[@yonpython9480]

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?

[@unnikrishnansanthosh]

creativity has no limits as far as BAS is considered

[@HowtoPowerBI]

🙏 thanks

[@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

[@totvabe1]

Impressive Bas, as usual on your channel.

[@HowtoPowerBI]

Much appreciated! Happy to see you here 😎

[@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]

🤪👍

[@pawewrona9749]

Amazing, you really squeezed maximum out of this visual. Very well done!

[@personalsigh]

Tried this but the custom label refused to allow me to add the description in

[@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

[@ManishKumar-eu1qw]

@How to Power BI how to pass parameter to public URL ?? please send me a solution i hope You Solved it

[@edwinarchico439]

Outstanding 🎉, in addition to storytelling

[@HowtoPowerBI]

Thank you! 🙂 happy to hear you like it

[@pabloperez72]

Hi and congratulation for you work. How would you do it with more than 1 milestone per date?

[@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?

[@MT-oy2uk]

Beautiful. I would also try to add zoom slider :)

[@HowtoPowerBI]

That would be cool!

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

[@andreicostin3]

Amazing as always, gotta try it on my reports as well :D . Thanks for keeping us updated with all new features 🎉🎉

[@HowtoPowerBI]

Please do tey ale let me know :)

[@HiYurd]

Excellent job. Really like that PBI visual.

[@JoleneTrinh-f4e]

where can I find the data set to practice?

[@HowtoPowerBI]

Download link in the description

[@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]

:) download link is in the description

[@marksant5488]

And I thought I knew the possibilities of PBI... Oh well... :D Thank you for your awesome and useful trainings.

[@HowtoPowerBI]

PBI has a lot to offer haha especially with all the new buttons you can click now :)

[@narendrababu2287]

Always something new🙂😀

[@HowtoPowerBI]

:):)

[@perfectionist6624]

True

[@shanmugavelayutham1394]

Sir, selectedvalue is not working RN.

[@karaboralekoala1012]

Wow impressive really✊✊✊💥💥

[@HowtoPowerBI]

Thx😊👍

[@elishmuel1976]

I can't incorporate your tips fast enough. You make me look like a superstar!! Can't thank you enough, Bas. 👍

[@Wzxxx]

I really wish I could use UNICHAR(10) for custom labels. Everything in Power BI is a hack. Simple stuff is hard to make. My friend used Tableau. It is like comparing software from 90's (PBI) against today's software (Tableu) in every aspect.

[@mutantlabor]

How did you create the dimDate table and what is its purpose?

[@joaorataoo]

Amazing Bas!!! Your capability to blend imagination with tech skills is fantastic! Congratulations!!!💯💯💯💯💯

[@HowtoPowerBI]

Thank you Joao :) Cheers!

[@reniellopez5479]

Hello. What’s inside the dimDate? Thanks a lot!

[@kadirkkkk]

very creative approach, well done

[@HowtoPowerBI]

Thank you very much!

[@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]

I totally agree! Sometimes the workaround takes way too long (thinking doing and DAX) for the benefit

[@JorgeSanchez-um7io]

Thanks for sharing! You make me love Power Bi!! You are the great master: Crear explanation and easy to replicate

[@HowtoPowerBI]

Wow, thank you Jorge, this is really great to hear :)

[@sanumpzha]

See how happy he is while talking about Error bars.😊😊 Nice video Bas👍

[@HowtoPowerBI]

Absolutely one of the best features in pbi

[@sanumpzha]

@@HowtoPowerBI Yes, i love it❤️

[@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]

Will try but it’s generally strange to see.timeline vertically

[@susantadas8213]

Next level visual though we should need to add custom tooltip to minimize the data label.

[@HowtoPowerBI]

Always an option:)

[@LeighRadmore]

Another clever banger! Nice work

[@HowtoPowerBI]

Appreciate it! :)

[@mtavassoti]

Error bars not Arrow bars 😂😂😂 it's confusing me every time you pronounce that 😅. Thanks for great videos.

[@HowtoPowerBI]

Just imagine the confusion once arrow bars actually get released 😳

[@dharmendarrana4191]

How to create same chart in Excel.

[@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]

Ah 😎 cool, nice to see you needed thsi visual!

[@gezin_longuevilleosaer4245]

Magic Bas, as always

[@HowtoPowerBI]

🪄thanks :)

[@cedriccot7519]

You are the man , thank you for posting

[@HowtoPowerBI]

😎 sure , thx for watching

[@kukeleku13]

Holy moly this is awesome!

[@HowtoPowerBI]

Glad you like it!

[@CrazyT0wn]

Great instructions as allways! your the man!

[@HowtoPowerBI]

I appreciate that! 🙏 thanks

[@rohanbhattacharyya6600]

Cool and very useful stuff..

[@andysmudge4849]

Great as usual

[@HowtoPowerBI]

Thanks Andy glad you think so! 😊

[@bryanbradford9421]

Nice! Can't wait to try that out!

[@HowtoPowerBI]

You should! Many many options!

[@ChannelRush-id4yx]

Very nice Bas

[@HowtoPowerBI]

Thanks for watching

[@yannkitson116]

Great stuff! Thanks for sharing :)

[@HowtoPowerBI]

Glad you enjoyed it!

[@spen2431]

Brilliant... just brilliant. 💥💥

[@HowtoPowerBI]

😊 thx’

[@Дарія-в3к]

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

[@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]

Right? FOMO is real… thanks for the kinds words and keep rocking! 😎👍

[@jahmed525]

@@HowtoPowerBI FOMO indeed!! :D

[@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

[@bananageorge2133]

I watched this a while ago and thought it was cool - coming back to it, this is cool, useful, explained well.. thanks so much.

[@emtatu]

This is brilliant!

[@HowtoPowerBI]

Glad you think so

[@tubeitz]

Super!!

[@HowtoPowerBI]

Thank you! Cheers!😎

[@gersinhopinto1978]

amazing

[@HowtoPowerBI]

Thank you! Cheers!

[@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

[@zammam5509]

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

[@MagdyTawfikA]

Much appreciated!

[@jim5400]

How do I display events on a parallel line (in date order) please?? Your videos are amazing thanks so much!

[@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 :}

[@mugeshkannan3776]

Please add full design😊

[@youtubegirl3592]

please share the data file you used during the video. Thanks.

[@HowtoPowerBI]

See download link in description

[@jimmypoopap]

Great new design love it

[@HowtoPowerBI]

Thank you Jimmy! Cheers!

[@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

[@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?

[@andrekroker420]

It´s hard to describe in words how incredible your work actually is! Thank you a lot!

[@HowtoPowerBI]

Wow, thank you Andre! :) 😎

[@andrekroker420]

@@HowtoPowerBI Dear Bas, how to handle multiple events for the same date?

[@diegolozano2397]

Thanks a lot, great viedo, hugs from Colombia

[@perfectionist6624]

You are superb ❤

[@HowtoPowerBI]

Thank you so much 😀

[@maksymkoliada1526]

Simply the best !

[@HowtoPowerBI]

:) thank you for watching!

[@bananageorge2133]

Many thanks ~

[@Saif_Ali_Khan_1301]

you are awesome.

[@lijunchen]

Another terrific video! I have not known the errors bars are so useful until today.

[@iamkalp6]

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]

thanks for those nice words! 😊

[@erhaneren2122]

Hey man. It is a great video. How did you connect them?

[@mutumakimathi]

So great!

[@NukeIncharge]

well, that trimmed bared looks great! and as usual great video.

[@HowtoPowerBI]

Oh thanks 🧔🏻‍♂️😎🤪

[@Zorro.Arslan]

Great tutorial and ideas. What if we add start date and end date of the events! If any tip plz

[@miguelbenito7992]

Awesome!!!

[@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]

Thank you very much! Yeah trying out every button :)

[@PedroNalin]

Awesome! Thanks for sharing!!

[@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]

Definitely would look better! 😎🔥

[@baskis69]

You are a visual wizard... thank you very much for sharing¡¡¡! 👏👏👏👏👏

[@HowtoPowerBI]

Thank you! Cheers!

[@LDP-z1l]

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]

amazing! congratz hope you like the new position

[@1yyymmmddd]

There seems to be no Custom labels toggle button any more in the latest Power BI version.

[@HowtoPowerBI]

Now it is just called value field under the data label formatting options

[@1yyymmmddd]

@@HowtoPowerBI Isn't it a shame they do not respect CR and LF in data labels :)

[@HowtoPowerBI]

@@1yyymmmddd you can have multiline labels

[@parveenbhardwaj4533]

It is amazing..Well done, Thank you very much for sharing 👏👏

[@HowtoPowerBI]

Thank you! Cheers! 😎

[@Lily-g6s2m]

Thanks for this great video

[@kennethsmith9610]

Am I missing something? Does this depend on the table dates being in chronological order matching the index column?

[@yonpython9480]

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 :(

[@romanmagic9952]

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]

Add the "event" column in the "Legend" field. That does the trick for me.

[@ScottCai-f1b]

Nice and useful video!

[@HowtoPowerBI]

Glad you think so!