The ART of Subtle ANIMATION in Power BI
Ғылым және технология
UPCOMING POWER BI DESGIN TRAINING! Join me here :)
my.datatraining.io/pages/powe...
In this video I show you how to use animated images in Power BI to uplift the report design.
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:55 What are we gonna build
01:39 Basic set up for the new card visual
03:46 Creating the growth rate measure for the label
08:19 Adding individual card titles
10:18 Creating the animated images ( GIFs )
14:58 Setting the loop count to 1
16:12 Adding the images to the card visuals in Power BI
20:35 Refining the image measures
23:57 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
Пікірлер: 194
Learn everything I know about designing Power BI reports datatraining.io/powerbidesigntransformation
Bas your work is outstanding and a blessing to the community! Keep up the great work 🎉❤
@HowtoPowerBI
9 ай бұрын
definitely will - that's really nice to hear thanks! 😊
This might be the best channel about Power BI !
This is amazing. I’ve used so many of your tips in my reports. Thank you!
It was incredible! Easy to understand & everyone can learn from you! Thanks master! 🙏
@HowtoPowerBI
9 ай бұрын
Glad to hear that! thank you! 😊
Amazing stuff, as usual. Thanks again for another great content, Bas!
Thank you, Bas! I can't believe how creative your tutorials are, and how easy to follow, and how helpful!
@HowtoPowerBI
9 ай бұрын
Thank you for always supporting the channel and being here! It means a lot :)
@alicedwonderland7733
9 ай бұрын
@@HowtoPowerBI you know, more videos on integrating PowerApps with Power Bi would be great for lots of people, I think. If you get around to doing some, there will be champagne popping :)
Great to find you here on KZread. as a new user to PBI, I love your energy and videos.
10/10 explanation, 10/10 usefulness. Way better use than random icons in a serious report. If you make the GIF run faster (say 0.15 sec) and use an arrow made of 3 lines (idk how to describe it) the effect is subtler but the attention is drawn subconciously anyway.
@HowtoPowerBI
9 ай бұрын
yea :p the gifs themselves could be prettier -> I guess you mean more like this ⇅ , bit more simplified and elegant - agree
From Mexico , Thanks for your Videos
Thank you for this. Analysts need to understand that elegant animations can enhance a report. You mention animation to analysts and everyone just screams "No!!!" Great video!
Bas as usual great stuff. I have a video request - and it's something i know MUST be a common problem that people face. Changing source file location from a local file to a sharepoint location. I don't know why - but you seem to have a way of communicating that I understand better than other content producers on here. I know this is not a 'sexy' topic - not like visualisations and subtle animation - But i feel like most people would end up just rebuilding the report from scratch rather than changing source. Love the increased low of videos coming our way amigo.
Thanks for all your efforts 🙏
You are a GENIUS! Thank you!
Hi Bas, Thanks for another awesome video on GIF, Appreciate your efforts to eductate everyone with your community..always waiting for next 💎 from you.❤
@HowtoPowerBI
9 ай бұрын
😎👊😊
You never disappoint! Well done, Bas!
@HowtoPowerBI
9 ай бұрын
thank you so much 😊
I love to learn ways to draw attention to some parts of the report, this one is brilliant ❤
@HowtoPowerBI
9 ай бұрын
Glad you enjoyed it! thank you 😊
Amazing stuff! Thank you for sharing your knowledge and skills.
This is AMAZING and superinformative as always. So much information here, I already saved it for future❤ Thank you!!!!!
@HowtoPowerBI
9 ай бұрын
Glad it was helpful! thanks for watching! 😊
Absolutely BRILLIANT... Your creativity and logical presentation make it a pleasure to watch and LEARN. Thank you, Bas
That was awesome ❤ Thank you 🎉
WOW! What a fantastic video and demonstration of creative problem solving. Thank you so much!
Great video as always! Honestly I don't know what I'm more happy about. Of the animation or the discovery of the shortcut window + Period :D
Again and again, you are amazing
Oh man, this tutorial was just great. Amazing content. Keep it up, you are an amazing teacher 💪
Informative! Great Job 👍🏼
dude your titurial and your explanation out from heart ❤❤❤❤❤❤❤❤
Amazing🎉👏Thanks for sharing👍
Thanks Bas for sharing such valuable content !!
@HowtoPowerBI
9 ай бұрын
thank you for watching again 😊
No way ChatGPT can give this kind of Quality Content.
@walquerglenanne3903
9 ай бұрын
Yet
@Freeflier1978
3 ай бұрын
There is a custom GPT that is trained for Power BI/DAX. Makes brainstorming custom DAX queries and measures easy. Plus I make custom d3 and html viz's combining Bas' tips and gpt js/html ones. My SharePoint site I designed with embedded Power Bi reports looks 100% like a web app
Fantastic as usual, thank you!
@HowtoPowerBI
9 ай бұрын
Glad you enjoyed it!
I'd really like to see a video about forecast with a linear regression calculation. What's your approach? Date range management, dataset requirement,...🙏
Again - awesome!
straight into my sales dashboard, wonderful one, thanks for sharing BAS
@HowtoPowerBI
9 ай бұрын
YEAH! 😎it made it to your dashboard woohoo
Thank you so much!
Welcome back - We missed you
@HowtoPowerBI
9 ай бұрын
lol :p I was only gone for 3 days though since my last long video 😅
Just amazing!
@HowtoPowerBI
9 ай бұрын
happy to hear you like it! thx for watching 😊
Man You're a legend!
Next f'kin level! Thanks for this mate, using it today.
@HowtoPowerBI
9 ай бұрын
😎👊 awesome
Very creative way to add a gif into card visual, thanks Bas!
Thank you for this awesome tip!! 👍 One suggestion: Don't use 'Transparency' with Gradient FIll in PowerPoint when making a GIF animation. I learned while trying this out that semi-transparency is not supported in an animated GIF. 😢 So if you export an animation of an image with gradient fill involving transparency, you will end up with an awkward result. I find that the best compromise is to use gradient fill using the color matching the background color in the report.
Great video, Bas. Thanks a lot!
@HowtoPowerBI
9 ай бұрын
Glad you liked it!
Awesome! Thank you for sharing your knowledge and skills.
@HowtoPowerBI
5 ай бұрын
thank you for watching! 😁😊
Excellent 🎉... thanks for sharing
learned something good today..thanks bas for sharing and putting in the effort of creating…
@HowtoPowerBI
9 ай бұрын
Glad you enjoyed it 😊
Thank you.
You are a Legend!
Thanks for sharing Bas 👍👍
@HowtoPowerBI
9 ай бұрын
thank you for watching 😊
Love this one. So cool!
@HowtoPowerBI
9 ай бұрын
😊😎
Awesome!
This is awesome 👏
@HowtoPowerBI
9 ай бұрын
😎👊😊
Thanks for an Awesome video, these have been helping me so much.
@HowtoPowerBI
9 ай бұрын
Glad you like them! 😊 thx for watching
Your videos are treasure for us. It keeps me motivated to continue with PowerBI else I would be lost in boredom. You are a saviour ❤ 22:03
Simplemente espectacular. Eres "monstruo" Bas. Saludos cordiales.
Just excellent, excellent, excellent. And I learned also about web pages where I can edit gif's and post images in internet since a local file and I think it'svery usefull. Thank you Bas for the video.
@HowtoPowerBI
9 ай бұрын
thank you so much for watching 😊
Great one!
@HowtoPowerBI
9 ай бұрын
Thanks! 😊😁
Well done as usual😊
@HowtoPowerBI
9 ай бұрын
Thanks again for watching my videos!
amazing
You are just awesome!
@HowtoPowerBI
9 ай бұрын
😊😎👊
Great content!! Can we host the images in onedrive or SharePoint?
Amazing ❤
@HowtoPowerBI
9 ай бұрын
😊thx!
excellent
As usual awesome....🙂
@HowtoPowerBI
9 ай бұрын
thank you for watching again 😊
Just amazin 🎉
Really interesting. Add a bit of WOW factor. I will try this in future developments. Great work !!
@HowtoPowerBI
9 ай бұрын
thanks! awesome 😎👊
How do you even come up with these ideas? AWESOME!
@HowtoPowerBI
9 ай бұрын
spending too much time in power bi 😅
Newbie to your channel, but 💕 it already.
@HowtoPowerBI
9 ай бұрын
Thanks for subbing!
Hey great way of teaching and amazing content. Can you please make a video on end to end project .
Nice solution Bas! I know that keeping single visual and multiple measures is better for performance, but it hurts how much repetitive code needs to be created (I know its just PBI limitation)
Hi @bas. Your video series is so much helpful for day-to-day work and Thanks for that. Also would like to know what are the resources I can use be an expert on Dax like you?🙂
Thanks ❤❤❤
@HowtoPowerBI
9 ай бұрын
thx for watching 😊
Outstanding!!! I am a beginner and your video was easy to follow..thank you so much!! Do you have a video on how to creat the Sales Development slicer shown in this video?? Thanks in advance 🙏🤩
Superb Bas 👍
@HowtoPowerBI
6 ай бұрын
Thanks for watching Nigel
Excellent tutorial!!! Can the up and/or down arrows link be pulled from SharePoint Folder?
Thanks for the amazing video. May I know the shortcut for bringing up the interface you took the icon from, thanks.
Thanks Bas! I love your videos, it's very instructive and easy to understand. If you cannot use links to outside ressources, can you do a similar effect with SVGs and a transition?
@HowtoPowerBI
8 ай бұрын
yes you can 😉 check out my latest video
Hi Bas, your insightful contributions are greatly appreciated. If it's convenient, could you please share which video editing software you utilize?
@HowtoPowerBI
9 ай бұрын
thank you. premiere pro and after effects
Nice explanation
@HowtoPowerBI
9 ай бұрын
😊 thank you
Beautiful! Challenge: is it possible to build a filter with button style? (Change style depending on the state). Couldn't find anything
Asum Bas! I am decently use this content for my next project!
@HowtoPowerBI
9 ай бұрын
awesome 😎👊
Fabulous video, one question pops out: how did you manage to put all the tools on the sidebar(data, filter, selection, bookmarks pane) ? Do i need to be sign in?
Can i use this GIF effect in button visual? ( when user click that button, it has to play the GIF one time)
Hi, I am very much keen on knowing if a Matrix visual COLUMNS can be shown/hidden with the help of buttons(like in Excel + & -) not with bookmarks and page navigations.. is there a way to achieve this.. please help/share some knowledge about the same. Thank you 😀
Man you are way out of the league. Speak of thinking out of the box. Question : You uploaded the gif in website to obtain a link. Will the link expire or not?
@HowtoPowerBI
9 ай бұрын
it doesn't expire :) .. but you give them a license to do whatever with the image -> With regard to any file or content you upload to the public portions of our site, you grant PostImage a non-exclusive, royalty-free, perpetual, irrevocable worldwide license (with sublicense and assignment rights) to use, to display online and in any present or future media, to create derivative works of, to allow downloads of, and/or distribute any such file or content, including embedded (hotlinked) into third-party websites otherwise not affiliated with PostImage.
this is cool..
@HowtoPowerBI
9 ай бұрын
Hahah right?
I have an urgent question and I'm not able to find a solution. I want to create a cascading filter feature with 2 filters "brand" and "sub brand". The point is when the brand slicer is cleared it should automatically clear the selection of the dependant slicer (sub brand). Would really appreciate if you help me with this one.... Thanks in anticipation
Great Concept and Explanation! But one question: How do you manage to get the time slicer to work with the up and down arrow when in your Dax code you always use the current Month and past Month to calculate the numbers? Please correct me if my question doesnt make any sense :D I just cant wrap my head arouns it!
Bass - надо упомянуть .Что для создания GIF >>> нужен офис 365 !
Insano!!!
@HowtoPowerBI
9 ай бұрын
first time i see that emoji 😅 lol ! thx 😁
Bas, Please Help!!! As I said below excellent tutorial. I set up everything as you showed in the video, I saved my up & down arrows on Sharepoint as url's. Copied the link from SharePoint and set up the measures and formatting as you did. The gifs are not working:( How do you get the gifs to work if they are saved on SharePoint?
Thanks for your sharing. How to move the background of Gif?
@HowtoPowerBI
5 ай бұрын
check video timestamp 10:50 .. there it is explained
Boss i have 4 visuals in one dashboard, all are based on various date columns, how can i use a single slicer to control all those visuals for a specific date duration, if anyone can help thanks
brilliant. while I am wondering will it be easier by using svg code?
@HowtoPowerBI
9 ай бұрын
let me try and I ll let you know 😁
I wonder for a business dashboard one could host the GIF in a SharePoint/OneDrive area and hyperlink to that (so it stays inside company firewalls)?
Bas you beast, would you mind dropping those links for the Gif's arrow down and up since you did them already
@HowtoPowerBI
9 ай бұрын
yea of course 😊 just uploaded it as well
رائع جدا
@HowtoPowerBI
9 ай бұрын
شكرًا لك
Boss you are great 😃.. May please make a video for texture fill in chart,pie column instead of solid colour. This is help to go green nature to eliminate colour usage.. in printing report ❤
@HowtoPowerBI
9 ай бұрын
thx for the idea!
@56ritikkrraj40
9 ай бұрын
@@HowtoPowerBIWaiting for the video ❤
Amazing content, as usual! One small remark: I was a little confused about the type of slicer you use in this specific report. Perhaps it would make more sense, from a user perspective, to use a slicer with monthly increments instead of a continous date slicer?
@HowtoPowerBI
9 ай бұрын
yea that could work too 😊
@psz34
9 ай бұрын
Why?
@tetrahelix_
9 ай бұрын
Because the visuals in this report shows %monthly changes. However, using the current slicer in the report, the user selects a period between two dates, rather than a specific month. If a user selects the period Jan 4th - March 27th in the slicer, I reckon it doesn't make a lot of sense to show %monthly change in the visual. It would make more sense if the user selected "April", for example, and then was prompted with totals for April as well as %changes compared with March. Does that make sense? I could be missing something.
Please how did you bring out the little icons? I use windows.
@HowtoPowerBI
7 ай бұрын
windows key + . (period)
Well I tried this, but it doesn't work for me. When I tried applying the field value under image URL, and I click the GIF DAX it doesn't populate. I tried clicking other measures, still the same. Is it a bug ? or am I doing it wrong ?