@@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 :)
Your videos are like watching Fine Art in making, everything looks so easy, until we hold the paint brush :) Thanks a zillions for such amazing 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.
I'd really like to see a video about forecast with a linear regression calculation. What's your approach? Date range management, dataset requirement,...🙏
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.
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!
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?
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!
Hi Bas! One quick question, I have created this exact same visualization, it was one hell of a learning. Thanks for it. However, when I exported this to PDF, I loose all the GIF. Any way out that I can have the images in place of GIF, only while exporting to PDF.
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?
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.
Hi Bas, Thanks for another awesome video on GIF, Appreciate your efforts to eductate everyone with your community..always waiting for next 💎 from you.❤
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 🙏🤩
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
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?
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 😀
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?🙂
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?
Hi, thanks for showing the tutorial, but can you also let us know how to calculate the sales USA and Sales USA PM measure in the video ?, I would like to create similar one but with comparison to Last year
Great video. 2x thoughts however. 1. I am pretty sure that PowerPoint can control how many times the animation loops? 2. some of your percentage change is over 2000%, are those numbers truly correct? Thanks
oh really that would b nice! I tried but couldnt figure it out - the animation within ppt you can set to loop 1x but not the exported gif or ? .. I believe the numbers are correct but also not really the point of the video
@@HowtoPowerBI thanks. will try out the PowerPoint element and come back to you. Quick question if I may please. On your video, you have a section specifically for measures (in addition to say your dimdate table or your source data table) ... how do you do that please?
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.
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
My problem look like this: I want connect 2 table by columne id. In table 1 id is saving in full number like 6-123-01, 6-123-02,... But in table 2 id can be saving like 6-123-% or %, where % means any data. I wonder if In Power Query I have sth what reaplece % in my data and i can connect 2 table
Hi, I try to apply this, but have a question, how did you pop out the icono panel, where u chosed the icono from...whats that? i kind of stuck there.Thanx in advance
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)
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
I am not able to embedded a GIF in my report due to company restrictions, what alternate way i can use? I tried uploading on OneDrive and SharePoint but no luck.
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 ?
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.
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?
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.
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 ❤
Learn everything I know about designing Power BI reports datatraining.io/powerbidesigntransformation
This might be the best channel about Power BI !
Thank you, Bas! I can't believe how creative your tutorials are, and how easy to follow, and how helpful!
Thank you for always supporting the channel and being here! It means a lot :)
@@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 :)
So very happy I found this channel. My reports have improved drastically in PBI since finding it.
Great content!!
Can we host the images in onedrive or SharePoint?
It was incredible! Easy to understand & everyone can learn from you! Thanks master!
🙏
Glad to hear that! thank you! 😊
Your videos are like watching Fine Art in making, everything looks so easy, until we hold the paint brush :)
Thanks a zillions for such amazing 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.
yea :p the gifs themselves could be prettier -> I guess you mean more like this ⇅ , bit more simplified and elegant - agree
Excellent tutorial!!! Can the up and/or down arrows link be pulled from SharePoint Folder?
I'd really like to see a video about forecast with a linear regression calculation. What's your approach? Date range management, dataset requirement,...🙏
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.
Great to find you here on RUclips. as a new user to PBI, I love your energy and 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!
This is amazing. I’ve used so many of your tips in my reports. Thank you!
WOW! What a fantastic video and demonstration of creative problem solving. Thank you so much!
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?
Thanks for the amazing video. May I know the shortcut for bringing up the interface you took the icon from, thanks.
I love to learn ways to draw attention to some parts of the report, this one is brilliant ❤
Glad you enjoyed it! thank you 😊
Very Good well Done! Does it also work, when it is published to Power BI Service?
Welcome back - We missed you
lol :p I was only gone for 3 days though since my last long video 😅
From Mexico , Thanks for your Videos
brilliant. while I am wondering will it be easier by using svg code?
let me try and I ll let you know 😁
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!
Absolutely BRILLIANT... Your creativity and logical presentation make it a pleasure to watch and LEARN. Thank you, Bas
Hi Bas! One quick question, I have created this exact same visualization, it was one hell of a learning. Thanks for it.
However, when I exported this to PDF, I loose all the GIF. Any way out that I can have the images in place of GIF, only while exporting to PDF.
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?
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 AMAZING and superinformative as always. So much information here, I already saved it for future❤ Thank you!!!!!
Glad it was helpful! thanks for watching! 😊
Hi Bas, Thanks for another awesome video on GIF, Appreciate your efforts to eductate everyone with your community..always waiting for next 💎 from you.❤
😎👊😊
Bas you beast, would you mind dropping those links for the Gif's arrow down and up since you did them already
yea of course 😊 just uploaded it as well
Oh man, this tutorial was just great. Amazing content. Keep it up, you are an amazing teacher 💪
Amazing stuff, as usual. Thanks again for another great content, Bas!
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 🙏🤩
Hi Bas, your insightful contributions are greatly appreciated. If it's convenient, could you please share which video editing software you utilize?
thank you. premiere pro and after effects
No way ChatGPT can give this kind of Quality Content.
Yet
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
Amazing work Sir but I have a Question.
Is it okay to use measures into measure when it comes to optimization point of view?
How do you even come up with these ideas? AWESOME!
spending too much time in power bi 😅
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?
yes you can 😉 check out my latest video
Thanks for your sharing. How to move the background of Gif?
check video timestamp 10:50 .. there it is explained
Amazing stuff! Thank you for sharing your knowledge and skills.
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 😀
dude your titurial and your explanation out from heart ❤❤❤❤❤❤❤❤
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?🙂
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?
Hi, thanks for showing the tutorial, but can you also let us know how to calculate the sales USA and Sales USA PM measure in the video ?, I would like to create similar one but with comparison to Last year
straight into my sales dashboard, wonderful one, thanks for sharing BAS
YEAH! 😎it made it to your dashboard woohoo
Please how did you bring out the little icons? I use windows.
windows key + . (period)
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
Great video. 2x thoughts however. 1. I am pretty sure that PowerPoint can control how many times the animation loops? 2. some of your percentage change is over 2000%, are those numbers truly correct? Thanks
oh really that would b nice! I tried but couldnt figure it out - the animation within ppt you can set to loop 1x but not the exported gif or ? .. I believe the numbers are correct but also not really the point of the video
@@HowtoPowerBI thanks. will try out the PowerPoint element and come back to you. Quick question if I may please. On your video, you have a section specifically for measures (in addition to say your dimdate table or your source data table) ... how do you do that please?
ruclips.net/video/cGnWPua-cmo/видео.htmlsi=E_jdBnqIE7b393CU
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.
thank you so much for watching 😊
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
learned something good today..thanks bas for sharing and putting in the effort of creating…
Glad you enjoyed it 😊
Awesome! Thank you for sharing your knowledge and skills.
thank you for watching! 😁😊
Hey great way of teaching and amazing content. Can you please make a video on end to end project .
Can i use this GIF effect in button visual? ( when user click that button, it has to play the GIF one time)
Beautiful! Challenge: is it possible to build a filter with button style? (Change style depending on the state). Couldn't find anything
Hi! I have question, how i can in Power BI find any symbol?
I search sth like % in SQL.
not sure what ou mean / trying to achieve
WIndows key + dot ( . )
My problem look like this: I want connect 2 table by columne id.
In table 1 id is saving in full number like 6-123-01, 6-123-02,...
But in table 2 id can be saving like 6-123-% or %, where % means any data.
I wonder if In Power Query I have sth what reaplece % in my data and i can connect 2 table
Simplemente espectacular. Eres "monstruo" Bas. Saludos cordiales.
Hi, I try to apply this, but have a question, how did you pop out the icono panel, where u chosed the icono from...whats that?
i kind of stuck there.Thanx in advance
windows key + . (period)
Thanx@@HowtoPowerBI
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)?
is there any way to use gif from out Local Device?
you mean instead of hosting the images somewhere? You can , but not if you want to switch between gifs like in this example
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
You never disappoint! Well done, Bas!
thank you so much 😊
Very creative way to add a gif into card visual, thanks Bas!
Thanks for sharing Bas 👍👍
thank you for watching 😊
Again and again, you are amazing
Next f'kin level! Thanks for this mate, using it today.
😎👊 awesome
This is awesome 👏
😎👊😊
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)
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
I am not able to embedded a GIF in my report due to company restrictions, what alternate way i can use? I tried uploading on OneDrive and SharePoint but no luck.
svg's can also be animated
Thanks for all your efforts 🙏
Informative! Great Job 👍🏼
Just amazing!
happy to hear you like it! thx for watching 😊
You are a GENIUS! Thank you!
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 ?
Thanks for an Awesome video, these have been helping me so much.
Glad you like them! 😊 thx for watching
Man You're a legend!
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.
Can the gif be saved on a SharePoint site?
Should work yes, as long as ot is accessible
Amazing🎉👏Thanks for sharing👍
Really interesting. Add a bit of WOW factor. I will try this in future developments. Great work !!
thanks! awesome 😎👊
How to type the delta icon, i can't open that window have characters like that to choose?
windows key + "." (period)
Thank you 🥰
That was awesome ❤
Thank you 🎉
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?
yea that could work too 😊
Why?
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.
Thanks Bas for sharing such valuable content !!
thank you for watching again 😊
Newbie to your channel, but 💕 it already.
Thanks for subbing!
Excellent 🎉... thanks for sharing
You are a Legend!
Great video, Bas. Thanks a lot!
Glad you liked it!
Again - awesome!
Amazing ❤
😊thx!
Your Whole Layout of the PBI desktop Looks different. A Bit more Retro. How are u doing this?
Love this one. So cool!
😊😎
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 ❤
thx for the idea!
@@HowtoPowerBIWaiting for the video ❤
Bas is a genius.
Thank you so much!
Thank you so much!
thx for watchn!!!
As usual awesome....🙂
thank you for watching again 😊
I came across the same problem that measure was not applicable to formatting even after using FORMAT function. It was such pain in the a**.
hm, never had that.. what if you would wrap in a different function that returns text as output? or add & "" at the end
Well done as usual😊
Thanks again for watching my videos!