Build This Vertical Timeline in Power BI!
Vložit
- čas přidán 4. 07. 2024
- Join my Power BI Design training here: my.datatraining.io/pages/powe...
In this video I show you all the steps to build a Vertical timeline using only native visuals and features in Power BI. 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:21 Main structure of the timeline
05:48 Putting the periods in the middle
07:35 Making it prettier
09:59 Adding the vertical line
11:51 Adding the dots
16:43 Extra info labels
18:59 Indicator for the current period
21:28 Additional considerations
24:27 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 CZcams: 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 - Věda a technologie
More than 4000 views and less than 300 likes. Please give him a maximum of likes; the creativity and the huge time spent deserve all of our likes.
More thank likes Bas needs to be paid by Microsoft, he is perfecting their product for free
This is absolutely my favorite channel for learning how to use Power BI! Bas, your energy throughout your videos is really contagious and honestly makes this such a fun learning experience. Thanks for everything!! :)
You never cease to surprise Bas! Not sure I'll ever have need to implement this timeline (although you never know!), but just watching your thought process and seeing how you write your dax and structure your measures is great.
You're a great teacher. Make things very easy to understand.
Man, I'm delighted with your creativity! Very well done! Deserves extra likes!
The way I anticipate your videos ❤, I literally check your channel every single morning.
Thank you for sharing...you are a genius...your creativity has no limits!...Merry Christmas
the most creative data visualization channel, thank you for sharing this content with us!
Wow. Perfect result, and easy to follow guide.
Awesome sharing Bas! I've been following your videos to learn Power BI for a while now and I find them extremely easy to understand, and while I've successfully created a dynamic column chart where the data changes according to the selected years in my slicer, I'm facing an issue with the year labels. I want the naming of the years on the axis to also change dynamically based on the selected years in my slicer. Any guidance on how to achieve this would be greatly appreciated!
Brilliant! Love this and well explained for anyone to follow.
😊 thank you!
So creative and genius. Well done man.
Amazing as usual. Thank you so much for sharing.
Thanks for watching!!!! Glad you liked it
You are out of this world Bas. Hats off to you.
naaaah, I just know how to build a timeline in powerbi 😅 thank you!!! 😁😊
Amazing!🙂Thanks for sharing!🎉
You are really an inspiration for an upcoming trainer. You make things easier and simpler. Can we make a nice org chart on Power BI with the native visuals or with any custom visuals when our data feed consists of 4-5 levels with 40+ employees. If there is a way to build a proper org chat, could you please do a video on that. I've been searching for this since few weeks didn't find any useful information.
Very usefuf for us to study, thank you!
and would you pls have a video off how to realize to vertical scrolling shown the table in power BI? thanks~
Smart guy, very. Interesting approach.
Thanks for this, it works great, just wondering how to concatenex the days of the month...
marvelous !!, thank you for sharing
Thanks for watching another video of mine, appreciated
Simply beautiful
Hi Bas - great video! Easy to follow and the visual looks great. Would it be okay if you explained how to use the ConcatenateX function in this case, as I have multiple values for certain months. Thank you :)
This is weird, how CZcams knows I need this for my project !!!!
He Is Amazing 💪💪💪
AMAZING!!!!
It is awesome!
Brilliant!
Good stuff!
Hi, your way of explanation is really extraordinary. Keep up the good work brother.
Can you please answer if we can update slicer value based on selection from visual?
Or if there is some workaround?
That was impressive. I was trying to do something similar in the past and I couldn't. I have a doubt: is there a chance to do the 'label goal' with a "text wrap" to do a line break instead of adding the three dots "..."?
@HowtoPowerBI
THE VIDEO WAS REALLY GREAT, I WAS LOOKING FOR THIS TYPE OF CHART FOR A LONG TIME SO ITS VERY USEFULL BUT FACING ISSUE WILE REPLICATING THE VISUAL I AM STUCK HOW THE DATA IS BEING MAPED MAINLY THE DATA LABLES(UNABLE TO DISPLAY ON THE BARS) OR WITH THE STRUCTURE IF THE DATA SO IF POSSIBLE CAN YOU PLEASE PROVIDE ME WITH THE POWER BI FILE SO I CAN CHECK THE WAY ITS DONE
Excellent Bas!
☺️ thx for watching
Very good! But does'nt work if you have two goals on the same date. Did you know how to fix that? Thanks!
I have the same problem. I tried to fix it, moving the data for the same cell, but didn't work too...
Sir, you are amazing.. 🙂
Naah just know a bit of power bi ;)
hi, this is a very nice training for Power BI, I tried to implement it but what do you do when there are several milestones in the same month , The date appears only once and it turns out that milestones in that month are not shown, is there another way to solve this?
Great video Bas, thank you so much. Btw, how can i save your videos now? it dont show that option anymore =(
still there ( maybe you need to click on more options (the 3 dots) and then it shows +save )
Great video! I think the goal's extra string length issue could also be resolved (if you need the full text) by concatting the text with line breaks (UNICHAR(10))
Thank you so much for all this content
I dont think that works on a stacked bar chart or..?
@@HowtoPowerBI you're right! Thanks for the response!
Hi buddy
Can we create a rotating flip card that shows overdue count on one side and when it gets flipped , it will show overdue count of all 5 types
Can we do this using DAX ?
Genius !!!
☺️ thank u!!!
Super, will it work for vertical stacked bar chart?
Then you can do it like this
czcams.com/video/cVy6rQMcmkg/video.html
can this be done horizontally?
Can you make a video on how to create a Venn diagram in power bi, like all the possibilities to create one?
Thank you, can you share the data to practice please
should be there now 🙂
If you do a video on it, will be helpful for me.
thx for idea
Verbluffend, steeds benieuwd wat je volgende uiterst creatieve vondst zal zijn. Grote fan van je werk.
dankjewel! 😁
Hi @how to powerbi, i am unable to get the months in sequence and sometimes some months are missing where there is no goal. Please suggest a way ahead
Hi Bas, I'm unable to find the link o download files.
Please guide
Genius
Label goal measure returns only first value in the column. So in the graph also only one of the months have value, rest is zero. How to solve this?
Love your content. I was trying to replicate it but i don't see Custom Label Option under Values even though i have the latest pbi update dec 23. Could you please guide?
Did you turn on all the preview options?
Hi bas, I have a request, can you please let me know how to import the calendar meeting from Outlook of my colleague on my power bi desktop.
Get data, exchange online, entered the mailaddress, select msaccount, enter credentials
@@HowtoPowerBI I have already tried that but its grabbing my outlook meetings. But the requirement is I need a outlook meetings of my collogues without entering their credentials in my power bi desktop. Please suggest if there is any other possibilities.
I think that is not possible for a good reason :)
Perfect, perfect, i can use this in my project.
awesome 😁😎👊 have fun implementing
hello sir, please make video on how to make Plotly Sankey Diagrams in power BI
I created this visual and the moment i published it on service it is giving me error (Couldn't retrieve data for this visual, Please try again later) on Power BI service , While it is working fine on my PBI desktop.
sir please, make video on how to make Plotly Sankey Diagrams
please make video on how to make Plotly Sankey Diagrams
Looove ur videos, but if make us the 3dbi warhorse stock with power bi, oooooh mine ......
Bas for president 🎉
Haha oh… Ill stay at youtube
I just wanna check the price of your master course and seen the price. My brain was blown away.... The final price you kept is translates to $3000(USD) in my country. The price might be less in your currency but it was far way higher for us. One euro is 91 rupees in my country.
i realize that it is a lot for some parts of the world, but for some countries it is very good deal for the value you r getting. I cannot offer differentiated pricing, but do have training options that might be more in your budget like the learning path, maybe check that one out :)
@@HowtoPowerBI Yeah I know you are the best and of course people will the best content who takes your course. 🙂
One question is if there are multiple goals in a single month , how to show them?
This is great if the data is clean but what if there are numerous goals for the same month?
You could adjust it further to show multiple lines or use this visual to show the main milestones and a different visual to show the sub milestones
When I add label goals to data labels, only some appear. I double checked formats, dates, etc. but cannot figure why. Anyone else experience this issue?
Maybe just a space issue? Check also responsiveness, making elements smaller
🙏🙏👏👏
When I publish the visual to the Power BI service, the label measure values are automatically replaced with the placeholder measure values, in the dynamic data label settings. So, the line appears with 1, -1, 0.2, -0.2 etc instead of the months and goals. Has anyone else experienced this behaviour? Is it a bug of the Power BI service?
the visual does display the blue i icon and state "data labels in this visual were modified and may not match the corresponding values"
@@sacoroth42 Happening to me also... couldnt find a fix yet :/
Amazing… I feel like you’re making powerapps look weak when I see what Powerbi can do with your creativity
Pray tell, what is the sum that the Tableau team is willing to offer you to stifle your creativity on Power BI? I’m sure it’s a princely sum, but I hope you won’t be tempted to take it! 😉😉
1st comment
🎉😁
Crack!
😎👊