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
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 😎
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
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?
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
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?
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.
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?
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
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
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
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. 😅😅
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
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 :}
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.
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.
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.
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
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 😎
Congrats Angelos! 🎉 wishing you great success in your new promotion!
Congrats
Thanks for sharing! You make me love Power Bi!! You are the great master: Crear explanation and easy to replicate
Wow, thank you Jorge, this is really great to hear :)
Excellent job. Really like that PBI visual.
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
Another terrific video! I have not known the errors bars are so useful until today.
Holy moly this is awesome!
Glad you like it!
Magic Bas, as always
🪄thanks :)
Requesting you to create video for Microsoft Fabric plz
Really nice creativity! How much of your time is just spent tinkering around? Always impressed by your non-standard use of features
Thank you very much! Yeah trying out every button :)
amazing
Thank you! Cheers!
You are just amazing 🥰
Hey Bas, I'm recreating this at work and can't work out why only the events from 7 upwards are showing... any ideas? 🤞
Super nice!
Thanks!
Hello. What’s inside the dimDate? Thanks a lot!
where can I find the data set to practice?
Download link in the description
There seems to be no Custom labels toggle button any more in the latest Power BI version.
Now it is just called value field under the data label formatting options
@@HowtoPowerBI Isn't it a shame they do not respect CR and LF in data labels :)
@@1yyymmmddd you can have multiline labels
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!😊😊😊
Great to hear, happy I can help :):)
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?
I'm not seeing the ability to turn on error bars...has the feature been discontinued?
tutorial CARD (NEW) please
Yes yes in making ;)
looks like Tableau, nice job men!
Guess thats a complement;) haha thx!
Impressive Bas, as usual on your channel.
Much appreciated! Happy to see you here 😎
fantastic video bro. price trend really need this
💪
No doubt 👍😊
How about event start and event end.?
creativity has no limits as far as BAS is considered
🙏 thanks
Definitely like it. I dont get to have rhe possibility to set a custom data label. How can I get access to this feature?
Hi Valentin, it is in the may version (you need to enable it in the preview options under settings)
Thank you for the fast reply! I'll try it straightaway
Amazing, you really squeezed maximum out of this visual. Very well done!
Bas! The moment you say make sure to hit that subscribe button and meanwhile you make that wave with the hand is so funny 😂
🤪👍
Outstanding 🎉, in addition to storytelling
Thank you! 🙂 happy to hear you like it
Always something new🙂😀
:):)
True
Tried this but the custom label refused to allow me to add the description in
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
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?
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.
Beautiful. I would also try to add zoom slider :)
That would be cool!
Amazing as always, gotta try it on my reports as well :D . Thanks for keeping us updated with all new features 🎉🎉
Please do tey ale let me know :)
@How to Power BI
how to pass parameter to public URL ??
please send me a solution i hope You Solved it
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?
Wow impressive really✊✊✊💥💥
Thx😊👍
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.
:) download link is in the description
And I thought I knew the possibilities of PBI... Oh well... :D Thank you for your awesome and useful trainings.
PBI has a lot to offer haha especially with all the new buttons you can click now :)
Hi and congratulation for you work.
How would you do it with more than 1 milestone per date?
Sir, selectedvalue is not working RN.
I can't incorporate your tips fast enough. You make me look like a superstar!! Can't thank you enough, Bas. 👍
very creative approach, well done
Thank you very much!
Amazing Bas!!!
Your capability to blend imagination with tech skills is fantastic!
Congratulations!!!💯💯💯💯💯
Thank you Joao :) Cheers!
How did you create the dimDate table and what is its purpose?
Very nice Bas
Thanks for watching
Next level visual though we should need to add custom tooltip to minimize the data label.
Always an option:)
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
I totally agree! Sometimes the workaround takes way too long (thinking doing and DAX) for the benefit
Great as usual
Thanks Andy glad you think so! 😊
See how happy he is while talking about Error bars.😊😊 Nice video Bas👍
Absolutely one of the best features in pbi
@@HowtoPowerBI Yes, i love it❤️
Super!!
Thank you! Cheers!😎
Another clever banger! Nice work
Appreciate it! :)
Error bars not Arrow bars 😂😂😂 it's confusing me every time you pronounce that 😅. Thanks for great videos.
Just imagine the confusion once arrow bars actually get released 😳
How about a vertical view for this, to make more room for each daye event 🙄 Brilliant tutorial as always, really loving your content 👍👍
Will try but it’s generally strange to see.timeline vertically
How to create same chart in Excel.
This is brilliant!
Glad you think so
You are the man , thank you for posting
😎 sure , thx for watching
Brilliant... just brilliant. 💥💥
😊 thx’
Nice! Can't wait to try that out!
You should! Many many options!
Great instructions as allways! your the man!
I appreciate that! 🙏 thanks
Cool and very useful stuff..
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
Thank you Bas! I totally needed this tutorial. I’ve been struggling to figure how to do this and you showed me the way!
Ah 😎 cool, nice to see you needed thsi visual!
Great stuff! Thanks for sharing :)
Glad you enjoyed it!
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
Great new design love it
Thank you Jimmy! Cheers!
Much appreciated!
You are superb ❤
Thank you so much 😀
please share the data file you used during the video. Thanks.
See download link in description
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. 😅😅
Right? FOMO is real… thanks for the kinds words and keep rocking! 😎👍
@@HowtoPowerBI FOMO indeed!! :D
Simply the best !
:) thank you for watching!
Please add full design😊
I watched this a while ago and thought it was cool - coming back to it, this is cool, useful, explained well.. thanks so much.
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
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
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
How do I display events on a parallel line (in date order) please?? Your videos are amazing thanks so much!
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 :}
Thanks a lot, great viedo, hugs from Colombia
Many thanks ~
you are awesome.
So great!
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?
It´s hard to describe in words how incredible your work actually is! Thank you a lot!
Wow, thank you Andre! :) 😎
@@HowtoPowerBI Dear Bas, how to handle multiple events for the same date?
Awesome!!!
Hey man. It is a great video. How did you connect them?
Great tutorial and ideas. What if we add start date and end date of the events! If any tip plz
well, that trimmed bared looks great! and as usual great video.
Oh thanks 🧔🏻♂️😎🤪
You are brilliant and one of the most innovative person in power BI space, I have come across..keep it up..love your content..
thanks for those nice words! 😊
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.
Very cool
😎👊
Nice and useful video!
Glad you think so!
Super awesome - as always
Thank you! Cheers!
Awesome! Thanks for sharing!!
You are a visual wizard... thank you very much for sharing¡¡¡! 👏👏👏👏👏
Thank you! Cheers!
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.
Definitely would look better! 😎🔥
You are very clever!
Thank you! 😊
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.
amazing! congratz hope you like the new position
It is amazing..Well done, Thank you very much for sharing 👏👏
Thank you! Cheers! 😎