@@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.
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.
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.
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!
I'd really like to see a video about forecast with a linear regression calculation. What's your approach? Date range management, dataset requirement,...🙏
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.❤
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!
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.
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.
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.
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, 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
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?🙂
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)
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?
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?
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, 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, 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
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
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 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.
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
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.
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.
It was incredible! Easy to understand & everyone can learn from you! Thanks master!
🙏
Glad to hear that! thank you! 😊
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.
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
Great content!!
Can we host the images in onedrive or SharePoint?
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!
WOW! What a fantastic video and demonstration of creative problem solving. Thank you so much!
Great to find you here on TH-cam. as a new user to PBI, I love your energy and videos.
Absolutely BRILLIANT... Your creativity and logical presentation make it a pleasure to watch and LEARN. Thank you, Bas
I'd really like to see a video about forecast with a linear regression calculation. What's your approach? Date range management, dataset requirement,...🙏
This is amazing. I’ve used so many of your tips in my reports. Thank you!
Oh man, this tutorial was just great. Amazing content. Keep it up, you are an amazing teacher 💪
I love to learn ways to draw attention to some parts of the report, this one is brilliant ❤
Glad you enjoyed it! thank you 😊
brilliant. while I am wondering will it be easier by using svg code?
let me try and I ll let you know 😁
Excellent tutorial!!! Can the up and/or down arrows link be pulled from SharePoint Folder?
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.
Amazing stuff, as usual. Thanks again for another great content, Bas!
dude your titurial and your explanation out from heart ❤❤❤❤❤❤❤❤
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! 😊
Amazing stuff! Thank you for sharing your knowledge and skills.
From Mexico , Thanks for your Videos
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
Welcome back - We missed you
lol :p I was only gone for 3 days though since my last long video 😅
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
Hi Bas, Thanks for another awesome video on GIF, Appreciate your efforts to eductate everyone with your community..always waiting for next 💎 from you.❤
😎👊😊
Awesome! Thank you for sharing your knowledge and skills.
thank you for watching! 😁😊
straight into my sales dashboard, wonderful one, thanks for sharing BAS
YEAH! 😎it made it to your dashboard woohoo
Very Good well Done! Does it also work, when it is published to Power BI Service?
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?
Amazing work Sir but I have a Question.
Is it okay to use measures into measure when it comes to optimization point of view?
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!
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.
How do you even come up with these ideas? AWESOME!
spending too much time in power bi 😅
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 😊
Thanks for the amazing video. May I know the shortcut for bringing up the interface you took the icon from, thanks.
Really nice!! congrats
learned something good today..thanks bas for sharing and putting in the effort of creating…
Glad you enjoyed it 😊
You never disappoint! Well done, Bas!
thank you so much 😊
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
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.
Thanks for sharing Bas 👍👍
thank you for watching 😊
Thanks for all your efforts 🙏
Very creative way to add a gif into card visual, thanks 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 🙏🤩
Next f'kin level! Thanks for this mate, using it today.
😎👊 awesome
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
Again and again, you are amazing
Informative! Great Job 👍🏼
Simplemente espectacular. Eres "monstruo" Bas. Saludos cordiales.
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
You are a GENIUS! Thank you!
Thanks for your sharing. How to move the background of Gif?
check video timestamp 10:50 .. there it is explained
This is awesome 👏
😎👊😊
Thanks for an Awesome video, these have been helping me so much.
Glad you like them! 😊 thx for watching
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?🙂
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)
Hey great way of teaching and amazing content. Can you please make a video on end to end project .
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?
th-cam.com/video/cGnWPua-cmo/w-d-xo.htmlsi=E_jdBnqIE7b393CU
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
Beautiful! Challenge: is it possible to build a filter with button style? (Change style depending on the state). Couldn't find anything
Thanks Bas for sharing such valuable content !!
thank you for watching again 😊
Please how did you bring out the little icons? I use windows.
windows key + . (period)
Excellent 🎉... thanks for sharing
Really interesting. Add a bit of WOW factor. I will try this in future developments. Great work !!
thanks! awesome 😎👊
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?
That was awesome ❤
Thank you 🎉
Amazing🎉👏Thanks for sharing👍
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 😀
Just amazing!
happy to hear you like it! thx for watching 😊
Newbie to your channel, but 💕 it already.
Thanks for subbing!
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
Great video, Bas. Thanks a lot!
Glad you liked it!
Man You're a legend!
Bas is a genius.
Thank you so much!
thx for watchn!!!
Amazing ❤
😊thx!
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
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
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
Thanks ❤❤❤
thx for watching 😊
Nice explanation
😊 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.
Superb Bas 👍
Thanks for watching Nigel
Can i use this GIF effect in button visual? ( when user click that button, it has to play the GIF one time)
excelentes videos pero no le entiendo, por ejemplo cuando dice "year" en vez de "here" (19:41) a mí, como hablante latino, me cuesta entenderlo.
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
You are a Legend!
Thank you so much!
Love this one. So cool!
😊😎
Again - awesome!
As usual awesome....🙂
thank you for watching again 😊
Well done as usual😊
Thanks again for watching my videos!
Thank you.
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)?
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 ❤
Great one!
Thanks! 😊😁