3 Hacks to Work Faster in Power BI
ฝัง
- เผยแพร่เมื่อ 22 พ.ค. 2024
- Join my Power BI Design training here: my.datatraining.io/pages/powe...
In this video I show you my 3 hacks to work faster in Power BI. They saved me many hours every week and hopefully for you too.
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:50 Hack 1
07:28 Hack 2
20:50 Hack 3
23:57 End
---------------------------------
💻 VIDEO LINKS 💻
---------------------------------
Report Theme JSON Schema: bit.ly/3u4IUJk
---------------------------------
😍 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 TH-cam: 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 - วิทยาศาสตร์และเทคโนโลยี
Ever since I started implementing your visualization ideas and technique, my boss has been really happy with the visualizations I create, Man I cant thank you enough.
Nicceee!!! happy to hear that 👊
@@HowtoPowerBI Man we all love your passion bro. Thanks a billion.
I use the Power BI Sidetools extension. It creates a folder structure for the pbix with all the table definitions, measures, and a layout model/bim. Saving measures to github would be as easy as using the extensions "save to visual studio code" button, then doing a git push on the existing folder.
The great thing is this makes every visual and data model change readable. If you are regularly committing these changes to git, you can easily revert, mix and match, or reuse without even opening PBI Desktop. Once you've made your changes in Visual Studio Code, there's an option to save the changes back to the pbix file.
I just started following your channel. The content is thought out and explained in a way which is concise and easy to understand. I appreciate your going a bit deeper into the more challenging content as well.
Great video as usual. I love your video’s and use a lot of your ideas. This video is an eyeopener. I allready wanted to do something with JSON files but now I know where to start. And your tips about add-ins and Github…. I’d love to get started with. Thanks a lot.
This is such a life saver! Thank you!
Noted! I’ll start to looking for the right external tool to be added to my power bi🤗 Thanks a bunch for your awesome recommendation! I really need to save more time in the process 😅
This is huge lifesaver. Thank you!
Parabéns Mestre!
A comunidade do Brasil agradece.
obrigado!
This is solid gold. Generalizing and customizing🎉🎉🎉. Thank you
☺️ thx!!!!
Thank you so so much for amazing videos. Keep up the great work ❤✨️
Definitely will!
I love your videos, always very very useful! Thanks!
😁 very happy hear that , thx for watching them
What an amazing video!! I especially loved the first part, since I’m just now getting to where I keep using the same measures over and over!
Especially awesome after some time when you have a whole treasury of useful code templates ;)
Game changer lessons for me on the custom JSON file. This is amazingly helpful. Already implemented my first custom JSON with all of my normal standards. This is so great. THANK YOU!
Awesome 😎👍Straight away to implementation
Thank you! You have leveled me up 20 times over!
🚀🚀🚀 yey 🎉
you're absolutely great,many thanks to you
So nice of you, thank you!
Wonderful Bas. Thanks for the video, specially for the customer theme option.
thank you !! yes having a few good themes make it a looooot easier for the front end design
Excellent video, thank you!
Thx Chris ☺️
Very useful as always!! Thank you!
thanks for watching! 😊
Great Hacks, Bas!
Thank You very much for another helpful video
Glad you like them! 😁😁
Man you are saving a lot of time for me personally!
That’s awesome 😎 now u have time for an extra coffee ☕️
Great thanks :)
😊
Master BAS, thank you for sharing
My pleasure!!
Pls suggest an good datenpicker visual with date formatting, easy range selection with calender view. Powviz date picker is not working in my published report, says it cant work in the environment
Amazing! So useful 👌
😎👊
Just superb..❤
Thanks a lot 😊
You have video or can point me towards visual used for the sales performance bars bubbles @19:12 they are so slick! Perfect for something I am working on.
Such a useful video, thank you!! Do you have any plan of making a video about the most useful powerbi add-ins you use?
Thx for idea!!💡 yes maybe 🤔 will think about it
Great tips - Thanks!
I see @4:29 the AboveAvg measure and the MinMax before it uses a calculate function wrapped around the [Total Sales] measure. I thought a measure reference had an implicit calculate. I am still struggling with DAX, so could you explain why this is the case?
Yes, correct :) you don't have to put the calculate around a measure (was from a different example file) - a lot of people would take the file and then write sum(salescolumn) instead of a measure and then it wouldn't work.. that's why I left the calculate there
Valeu!
thank you so much for the support!!! 😁
Is there a website wherein readymade python codes are available and is tere a website where such codes can be sold?
Thank you for the awesome tips Bas! However, I'm having difficulty installing MSHGQM, I'm running Windows 11 and I keep getting the error "This Installation package could not be opened" Can you perhaps guide me on how to install it please?
Is it possible to set the default number of decimals for all values in the report anywhere? I mean, not for only one visual but for all?
Hello buddy. I tried to find the file content associated to the video but there are too many links and registration to your IO website only lead to links pointing to the TH-cam videos for this particular one. Any clues on the PBI file you copied the MinMax dax from etc ? thanks
So so lovely.
Thank you! 😊
Cam you please make a video on testing the reports after development using automation
thanks for the idea! :) will think about it
Hi Bas. What are your thoughts on using figma with PowerBi - in terms of design and UI?
its nice, but just another tool :) .. whatever you feel comfortable with and let's you create the design you have in mind.. for many people powerpoint is enough
Can you do a video on how to filter one field parameter slicer based on a different parameter field slicer? For instance, if my first parameter field contains Program, Teacher, Student and I select Program, I only want my second parameter field slicer to return Teacher and Student. The idea here is to allow users to determine the breakdown in a matrix. For example: See averages based on Program then Student or see averages based on student then program. I've searched and searched trying to figure out how this can be done. Thank you.
Here you go :) th-cam.com/video/nWgPynP9XDM/w-d-xo.htmlsi=toNDekr2Y4zNWPVK
Please create videos on power bi cloud services environment
What is 'QuarterNo' in the dax measure for MaxMin. Can you share the formula ?
that's the sortby column for quarter name (if you use all / allselected you need to put in the sortby column as well)
❤❤❤❤❤
😁
How can w have a dynamix totals linenin line chart appart from individual line for each legend
don't understand the question, sry
@@HowtoPowerBI sorry when we use a line chart, it shows values only for each field item. I want an additional line showing totals. I dont want to use stacked area charts
Very first measure you copied... MaxMin. Why did you put CALCULATE([Total Sales])??? Why is there a CALCULATE wrapping a measure?
the calculate is not necessary .. but often people would copy the code they see as in the file / video and then replace the measure with SUM(sales[amount])) , which doesnt invoke context transition and would need a calculate around it
@@HowtoPowerBI Wow, that's cool
Wha goree
?
it's not a tons of time... megatons 😄
😄 yes will say megatons next time lol
Suuuuuuuuper like !!
🎉🎈🍾🪩
This is amazing, saves me a lot of time in development, many thanks Bas!
Definitely does for me , if u share ur code / design assets with team members you save even more time